Conditional Formatting

[Anthony]

I need to change the fill color based on the values of other cells.
Ex. if A1 is not a null value and the cell I want to format A2 is a null
then I need A2 to have a red fill color and a certain text. If A2 isn't a
null then it should turn green. If A1 and A2 have null values then A2 should
be yellow.
So just to sum up
A1<>"" and A2 ="" then Make A2=Red Fill Color + text
A1<>"" and A2 <>"" then A2=Green Fill Color
A1="" and A2 ="" then A2=Yellow Fill Color
Thanks for the help all.

 

[T. Valko]

What version of Excel are you using?

 

[Jim Thomlinson]

Select Cell A2
Format | Conditional Format...

Condition1
Formula is
=and(A1<>"", A2="")
Format to a red colour

Condition 2
=and(A1="", A2="")
Format to a yellow colour

Condition 3
=and(A1<>"", A2<>"")
Format to a green colour

As for adding Text that is not possible with a CF. You will want to put a
formula in an adjacent cell to pop up the text. There is a way to do it with
the camera tool but it is kind of fussy to set up.
http://spreadsheetpage.com/index.php/oddity/the_camera_tool/

 

[Anthony]

Tank you works well.

Select Cell A2
Format | Conditional Format...

Condition1
Formula is
=and(A1<>"", A2="")
Format to a red colour

Condition 2
=and(A1="", A2="")
Format to a yellow colour

Condition 3
=and(A1<>"", A2<>"")
Format to a green colour

As for adding Text that is not possible with a CF. You will want to put a
formula in an adjacent cell to pop up the text. There is a way to do it with
the camera tool but it is kind of fussy to set up.
http://spreadsheetpage.com/index.php/oddity/the_camera_tool/