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.