Conditional Formatting

A

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

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

Anthony

Tank you works well.

Jim Thomlinson said:
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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top