Conditional formatting help

[Little Master]

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.

 

[EdMac]

With Conditional formatting you can do this is by having two conditions
the first being if the other cell is blank - no format;.

the second condition is if the cell has a value less/more than you
reference then colour it.

Go to conditional formatting > formula is > and write in the conditio
1, then click add and and do condition 2.

HTH
E

 

[Little Master]

i tried that thing also.but didnt worked for me.here is my file if u can
help me ?? http://rapidshare.de/files/17202439/a.xls.html

 

[dodong]

under conditional formatting choose formula then write this formula:

=if(isblank(a1),"",if(isblank((c1),"",a1<c1))

i hope this will help.

 

[Little Master]

Thanks friend but it didnt worked, i dont know why, but there is an
formula error.When i tried to insert a formula it highlited the "" &
says formula is incorrect.

 

[Peo Sjoblom]

Formula is and

=AND(A2<C2,COUNT(A2,C2)=2)


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Little Master" <[email protected]>
wrote in message
news:[email protected]...