Posted to microsoft.public.excel.worksheet.functions
|
|
In Excel, conditional format (font red) referencing another ce
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
|