Thanks TV.

I meant to use CF again with 'Formula Is' referring to cell A1.

If this post helps click Yes
---------------
Jacob Skaria


"T. Valko" wrote:

=$A$10

Where did the OP say the number would be 0? Using that as the CF formula,
enter any TEXT in the cell and the format will be applied.

Use one of these instead:

=COUNT(A1)
=ISNUMBER(A1)


--
Biff
Microsoft Excel MVP


"Jacob Skaria" wrote in message
...
Select A2Conditional FormattingSelect Formula Is and type the below
formula. Select color Red

=$A$10

If this post helps click Yes
---------------
Jacob Skaria


"Jafferi" wrote:

Cell A1 ~ I did a conditional format to change to red when a number is
entered.

My questions:
How can I tell Cell A2 that if A1 change to red, Cell A2 needs to change
as
well

Thank you in advance.