You have replies at your other post

--
Biff
Microsoft Excel MVP


"Becky" wrote in message
...
I would like to format A1 with "strikeout" if A3 is 0 (zero). How do I
write
that one?

"T. Valko" wrote:

Select cell C3

Goto Home tabStylesConditional FormattingManage Rules

Click New RuleUse a formula to determine...
Format values where this formula is true:
=AND(COUNT(A1,B1,C3)=3,C3<A1+B1)
Click the Format button
Select the desired style(s)
OKOK
Click New Rule again and repeat the above proccess for the second
condition. Use this formula:
=AND(COUNT(A1,B1,C3)=3,C3=A1+B1)

Then, OKOKApplyOK


--
Biff
Microsoft Excel MVP


"KMorris" wrote in message
...
Christine<

In Excell 2007, I want to be able to set a formula for a single cell
(c3)
such that it turns red when its numerical contents are =not(a1+b1 = c3)
and
the cell turns green when its numerical contents =(a1+b1=c3). How do I
set
both of these condiions for a single cell in Excel 2007?

Thanks,

Karen

"SteveG" wrote:


Christine,

Yes. In A1 go to Conditional Formatting. Change the Cell Value is
option to Formula is. Enter

=B1="Your Text"

Click Format, Font select the color you want. Click OK, OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile:
http://www.excelforum.com/member.php...fo&userid=7571
View this thread:
http://www.excelforum.com/showthread...hreadid=570036