![]() |
#3
|
|||
|
|||
![]()
Catalin
Thank you for such a quick reply. I was able to get the two Exacts to match but the Isblank condition is not working. I even put them in the order that you had yours, Red, Blue, Green. It doesn't matter what is in Column A, I just need the condition to be if cells C5 and down are blank or null highlight the row. Is it because the condition =Exact($A5,$C5) = False already has those rows highlighted in Blue? For example, Column A could have a name in that cell and Column C be blank or Column A and C could have names in each cell but they don't match. In this case should there need to be different conditions? It is strange that the ISBlank condition is working. The cells appear to be blank. Here's an example. Line 3 should be red because Column C is blank. Exact084ExactNot_Exact105Not ExactIsBlank104 =ISBLANK($C5) =TRUE applied to =$5:$6389 =EXACT($A5,$C5) applied to =$5:$6389 =EXACT($A5,$C5)=FALSE applied to =$5:$6389 I'll keep plugging along for now. I am sure I'm doing something wrong. Thanks again for your help. Laurie B. |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to set an equation with three conditions? | Jamal NUMAN | Word | 0 | 07-09-2011 06:05 AM |
![]() |
david_benjamin | Excel | 2 | 04-11-2011 11:30 AM |
![]() |
bundy5150 | Excel | 4 | 02-22-2011 10:00 AM |
![]() |
EclipticalD | Excel | 1 | 07-08-2010 09:50 PM |