I have some conditional formatting in column J on my worksheet that
checks if it is less than the value in column C. If so, the font color
is red. However, column C can also be blank sometimes and if I put a
value in column J, then it displays it in red font color, which I don't
want. Is there a way to add something to the conditional formatting
which will only display column J in red font if it is less than column
C and column C is not blank?


--
LAF
------------------------------------------------------------------------
LAF's Profile: http://www.excelforum.com/member.php...fo&userid=9656
View this thread: http://www.excelforum.com/showthread...hreadid=466060