Conditional Formatting - displaying text based on excel values

[ballcatcher]

I am hoping to get help on a conditional format issue. I want cell A1 to always display "Advertiser Name" cell with a simple conditional format of either red or green. I.E. I want the "Advertiser Name" in A1 to show conditional format green if the excel value in C2 is greater than 0. Using cell A1 again, I want the "Advertiser Name" to show conditional format red if cell C2 is less than 0. Is this possible? Any help would be greatly appreciated. Thank you.

 

[jtakw]

Hi,

CF, use formula, 2 rules:

Book1
	A	B	C
1	TRUE	<--for CF Green
2	FALSE	<--for CF Red	1
Sheet392

Cell Formulas
Range	Formula
A1	=C2>0
A2	=C2<0