I think that no one is able to understand my question properly.(because i am not able to explain it properly)here i am once again asking it in a different way.My problem is that, that i want to ignore blank i mean i had set a conditional formatting say
A B C D
24.9 25.9 25 25.8
22.6 23.4 22.5 23.3
If value in ColA is less than value in ColC, cell A1 is shaded blue OR if
value in ColB is greater than value in ColD, cell B1 shaded blue.
I have done above formatting but my problem is that if i dont enter anything in colC then also colA is shaded in blue similarly if i dont enter any value in colD then also col B is shaded.I mean i want to ignore the blank.I need , if col C is blank then the Col A must be normal .& if col D is blank & i enter any value in colB col B must be normal.I want to ignore blank.What should i do ?
Thanks in advance.
Thanks in advance.
Bookmarks