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.