Conditional Formatting
 

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.

Conditional Formatting
 

What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"Anthony" wrote in message
...
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.

Conditional Formatting
 

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...e_camera_tool/
--
HTH...

Jim Thomlinson


"Anthony" wrote:

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.

Conditional Formatting
 

Tank you works well.

"Jim Thomlinson" wrote:

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...e_camera_tool/
--
HTH...

Jim Thomlinson


"Anthony" wrote:

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.