Re: $$Excel-Macros$$ Re: Advanced conditional formatting

> > http://tutorialway.com/conditional-cell-format-in-excel/ visit this site -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

$$Excel-Macros$$ Re: Advanced conditional formatting

Dear Suresh, Attachment has been solved and re-attached. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 8/27/09, suresh k brave.sur...@gmail.com wrote: Sorry, Now with attachment On Thu, Aug

$$Excel-Macros$$ Re: Advanced conditional formatting

Hi Suresh... The Brave Man..!! Thanks a ton..!! -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 2009/8/28 suresh k brave.sur...@gmail.com Hi Dilip, Many thanks for your help. I tried without MID formula,

$$Excel-Macros$$ Re: Advanced conditional formatting

Pl. find attached excel sheet for query. Thanks Regards, Dhananjay On 8/28/09, Dilip Pandey dilipan...@gmail.com wrote: Dear Suresh, Attachment has been solved and re-attached. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com

$$Excel-Macros$$ Re: Advanced conditional formatting

hi,your answer is very good. When using the relative reference, the first cell in the row gets the right answer. However, when it happens in the next cell, the formula changes because I am using the relative reference. On Aug 28, 12:35 pm, Dilip Pandey dilipan...@gmail.com wrote: Hi Liuxin,

$$Excel-Macros$$ Re: Advanced conditional formatting

Hi Liuxin, Thanks for the encouraging words...!! Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 8/28/09, liuxin9...@gmail.com liuxin9...@gmail.com wrote: hi,your answer is very good.

$$Excel-Macros$$ Re: Advanced conditional formatting

Hi Suresh. Attached file has the scenario and the explanation for your query. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Aug 27, 2009 at 4:51 PM, suresh k brave.sur...@gmail.com wrote:

$$Excel-Macros$$ Re: Advanced conditional formatting

Dear Suresh, I think you forgot to attach the file. Please re-attach and send. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Thu, Aug 27, 2009 at 8:17 PM, suresh k brave.sur...@gmail.com wrote:

$$Excel-Macros$$ Re: Advanced conditional formatting

Suresh, This might help you http://www.mrexcel.com/hof001.php Norman On Thu, Aug 27, 2009 at 7:21 AM, suresh k brave.sur...@gmail.com wrote: Hi Guyz, Whenever we use conditional formatting it will be applied for current cell only. Is there anyway that if the condition is true the entire

$$Excel-Macros$$ Re: Advanced conditional formatting

Hi Dilip, Can you check this attachment. Its having three options TRUE, FALSE and Not available. In this case is it possible to highlight entire rows in different color based on the result. On Thu, Aug 27, 2009 at 8:03 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Suresh. Attached file

$$Excel-Macros$$ Re: Advanced conditional formatting

Hi Liuxin, This is because, when you use absolute reference ($ref$), conditional formatting logics on the entire row is checking if that particular reference is meeting the logics or not. Moreover, when you apply that logic towards right direction to cover entire row, the logic still checks only