Re: $$Excel-Macros$$ Conditional Formating Problem

Thank very much Ganesh Problem Solve On May 14, 2015 4:14 PM, "Ganesh N" wrote: > HI abbas, > > Use the conditional formatting with "Use a formula to determine which > cells to format' > > Regards, > Ganesh N > > On Thu, May 14, 2015 at 3:24 PM, Ali Abbas wrote: > >> Dear All. Hope u r all well.

Re: $$Excel-Macros$$ Conditional Formating Problem

HI abbas, Use the conditional formatting with "Use a formula to determine which cells to format' Regards, Ganesh N On Thu, May 14, 2015 at 3:24 PM, Ali Abbas wrote: > Dear All. Hope u r all well. > > I have two column with numbers. My requirement is if one column values is > greater than other

$$Excel-Macros$$ Conditional Formating Problem

Dear All. Hope u r all well. I have two column with numbers. My requirement is if one column values is greater than other then greater values color should be red and its smaller values color is green. How can I compare two columns by using of conditional. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)

Re: FW: $$Excel-Macros$$ Conditional Formating

; End If > > > > > > Next > > > > End Sub > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Prafull Jadhav > *Sent:* Friday, March 14, 2014 3:36 PM > *To:* excel-macros@googlegroups.com > > *

RE: FW: $$Excel-Macros$$ Conditional Formating

rior.Color = vbGreen End If Next End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prafull Jadhav Sent: Friday, March 14, 2014 3:36 PM To: excel-macros@googlegroups.com Subject: Re: FW: $$Excel-Macros$$ Conditional Formating Dear Sir,

Re: FW: $$Excel-Macros$$ Conditional Formating

gt; 9920553518 > > > > On 14 March 2014 15:12, Ravinder wrote: > > Pfa. if not receive... > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ravinder > *Sent:* Friday, March 14, 2014 3:08 PM > *To:* excel-ma

RE: FW: $$Excel-Macros$$ Conditional Formating

: excel-macros@googlegroups.com Cc: Soum Subject: Re: FW: $$Excel-Macros$$ Conditional Formating Dear Sir, It is not working.. Please let me know how I can select the all cell in sheet where cell format is "%" Regards, Prafull Jadhav 9920553518 On 14 March 2014 15:12

Re: FW: $$Excel-Macros$$ Conditional Formating

m [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ravinder > *Sent:* Friday, March 14, 2014 3:08 PM > *To:* excel-macros@googlegroups.com > *Cc:* 'excelvbacli...@googlegroups.com'; Soum > *Subject:* FW: $$Excel-Macros$$ Conditional Formating > > > >

RE: $$Excel-Macros$$ conditional formating to find amts to offset

:02 +0530 Subject: Re: $$Excel-Macros$$ conditional formating to find amts to offset From: prafulltjad...@gmail.com To: excel-macros@googlegroups.com Dear Santosh, find the same ...with 3)amts have to be equally opposite. Regards, prafull. On Mon, Mar 25, 2013 at 11:41 AM, अनिल नारायण गवली wrote

Re: $$Excel-Macros$$ conditional formating to find amts to offset

t; When the line items are identified with the above conditions those will >> be knocked off with each other since they are of zero value to the >> organization. >> >> They are open in the report with out any reason and were created >> mistakenly. >> >> Th

Re: $$Excel-Macros$$ conditional formating to find amts to offset

kenly. > > Thanks & Regards > > Santosh Kumar Subudhi > > santoshkumar.subu...@gmail.com > > -- > Date: Mon, 25 Mar 2013 10:26:13 +0530 > Subject: Re: $$Excel-Macros$$ conditional formating to find amts to offset > From: prafulltjad...@gmail.com > To: excel

RE: $$Excel-Macros$$ conditional formating to find amts to offset

& Regards Santosh Kumar Subudhi santoshkumar.subu...@gmail.com -- Date: Mon, 25 Mar 2013 10:26:13 +0530 Subject: Re: $$Excel-Macros$$ conditional formating to find amts to offset From: prafulltjad...@gmail.com To: excel-macros@googlegroups.com HI , find the same i

Re: $$Excel-Macros$$ conditional formating to find amts to offset

HI , find the same if it is as per your requirement . Regards, prafull jadhav. On Sun, Mar 24, 2013 at 2:27 PM, David Grugeon wrote: > I want to know where we are going next with this. What happens if the > amounts are different? > > > On Sunday, 24 March 2013, santosh subudhi wrote: > >> Hell

Re: $$Excel-Macros$$ conditional formating to find amts to offset

I want to know where we are going next with this. What happens if the amounts are different? On Sunday, 24 March 2013, santosh subudhi wrote: > Hello Group, > > I need a way to highlight the amts that I can offset with each other based > on the below conditions: > > 1) Customer should be same >

$$Excel-Macros$$ conditional formating to find amts to offset

Hello Group, I need a way to highlight the amts that I can offset with each other based on the below conditions: 1) Customer should be same 2) Profit Center has to be same I need to do this *with out macros.* * * Any type of help would be of great help. -- Regards Santosh santoshkumar.subu...@g

RE: $$Excel-Macros$$ conditional formating

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of rajeyssh Sent: Tuesday, September 25, 2012 1:50 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ conditional formating Hello Sir Required correction in conditional formatting. Pl

$$Excel-Macros$$ conditional formating

Hello Sir Required correction in conditional formatting. Pl. check the attachment and do the needful. Thanks -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Po

Re: $$Excel-Macros$$ conditional formating / formula

You can also try ... *=VLOOKUP($A2,ColA,1,0)* ColA=='PAYMENT ADVICE SHEET'!A:A -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Wed, Nov 16, 2011 a

Re: $$Excel-Macros$$ conditional formating / formula

So one way would be to create a named range, for example, ColA, and use the formula ='PAYMENT ADVICE SHEET'!A:A to define it. Then in the Bill Sheet, by selecting the ranges in column A starting from A2, use the formula option in conditional format and give this formula.. =MATCH($A2,ColA,0) Sampl

$$Excel-Macros$$ conditional formating / formula

BILL SHEET BILL NO DATE MONTH AMT . 096 10-05-11 Apr-1115000 097 10-05-11 Apr-11 35000 099 10-05-11 Apr-1164,300 098 10-05-11 Apr-11 6 *PAYMENT ADVICE SHEET* BILL NO

Re: $$Excel-Macros$$ Conditional formating help

Dear Sonu, Pls attach the solution file. Pls let me know was it helpful or any problem. Warm Regards Bhushan Sabbani +91 98208 26012 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tric

Re: $$Excel-Macros$$ Conditional formating help

I want seprate conditional formating for each cell . *Part No* *Min Qty* *Max Box* *Max Qty* *1-Mar-11* 981128 24 6 48 5 981250 32 3 48 4 986178 10 20 20 15 986179 20 40 40 2 On Fri, Apr 15, 2011 at 2:05 PM, ashish koul wrote: > try the attachment > > > http://www.homeandlearn.co.uk/e

$$Excel-Macros$$ Conditional formating help

Dear all , please find herewith attached file .I want some help about conditional formating. Matter is urgent. -- J.Gaurav Cell - 9327348097 -- -- Some important links for excel users: 1. Follow us on TWITTER

Re: $$Excel-Macros$$ Conditional Formating

Hi Pankaj, On internet you can find lots of learning stuffs on conditional formatting with good examples. On you tube as well there are some good video's on conditional formatting. Hope this will help. Regards, Deepak On Mon, Sep 6, 2010 at 12:43 PM, C.G.Kumar wrote: > Follow the link; > > > 1.

Re: $$Excel-Macros$$ Conditional Formating

Follow the link; 1.http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html 2. http://www.free-training-tutorial.com/conditional-formatting.html On Mon, Sep 6, 2010 at 8:36 AM, Pankaj Kumar wrote: > Hi all, > > i am new in msexce

Re: $$Excel-Macros$$ Conditional Formating

Hi Pankaj, In Excel if you go to conditional Formatting, you can find lot of options. A conditional Formatting is like this for example, If a student scores less than 30 marks he is fail and he scores more than 30 he is pass. Conditional Formatting is like either this or that. If you didnt underst

$$Excel-Macros$$ Conditional Formating

Hi all, i am new in msexcel wanted to learned use of conditional formating, cananyone helped me to learned conditional formatting ,,,for a brief example -- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com rajputpank...@yahoo.in* * rajputpankaj1...@r

Re: $$Excel-Macros$$ Conditional Formating

Dear Mahavir U can use following formula:- =OR(TEXT(A1,"DDD")="Fri",TEXT(A1,"DDD")="Sat") & apply it till last data in the column. Solved file is also attached. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New D

Re: $$Excel-Macros$$ Conditional Formating

:* Monday, November 23, 2009 4:41 PM > *Subject:* $$Excel-Macros$$ Conditional Formating > > Dear All, > > I want to highlight friday and saturday using conditional formating: > > > *A B* > DateDay > 01/11/2009 =weekday(a1) &

Re: $$Excel-Macros$$ Conditional Formating

Dear Mahavir, take a look on attached file. Regards, Mudassar Ramzan - Original Message - From: Mahavir Bhardwaj To: excel-macros@googlegroups.com Sent: Monday, November 23, 2009 4:41 PM Subject: $$Excel-Macros$$ Conditional Formating Dear All

$$Excel-Macros$$ Conditional Formating

Dear All, I want to highlight friday and saturday using conditional formating: *A B* DateDay 01/11/2009 =weekday(a1) 02/11/2009 =weekday(a2) 03/11/2009 =weekday(a3) 04/11/2009 =weekday(a4) 05/11/2009 =weekday(a5) 06/11/2009 =weekday(a6

$$Excel-Macros$$ Conditional Formating of more than one cell

Dear All, In the attached file, I want to format cells (a4 to l14) in a manner where row colour would be same as appearing in coloumn M. In other words, in row number 5, I want cells from A to L to be fileld in Green color, in row 6 in red color, etc. Is it possible to do so using conditional fo