Conditional Formatting

[LAF]

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?

[Casey]

LAF
try
=AND(C2<>"",C2>J2)
HTH

[cincode5]

LAF

The only way I could reproduce your situation was by inserting a space in
Col C. You might want to check to see if there are spaces and nullify them,
or rewrite the conditional format with a second criteria (as criteria #1) to
read:
Formula Is =$C$1 (and set the font to Black).

Again this has to be the first criteria. Conditional Formatting can have 3
criteria, but will stops when it reaches the first True occurrance.
--
Regards...


"LAF" wrote:

>
> 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
>
>