Thread
:
How to change cell colors based on an IF statement formula?
View Single Post
#
4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
Gord Dibben
external usenet poster
Posts: 22,906
How to change cell colors based on an IF statement formula?
Tom
FormatConditional FormattingCell Value is:
equal to......... ="1% variance exists"
Note the = sign.
Pick a Format from Patterns.
Gord Dibben XL2002
On 21 Nov 2003 11:09:58 -0800,
(Tom Woolman) wrote:
Hello. I am trying to do a simple color-coded exception report in
Excel and can't find any decent documentation on cell formulas (the
online help in Excel 2000 is kind of arcane).
I am trying to compare a cell value on two different sheets. If there
is a variance = 1% across the two cells, then I want to say "= 1%
variance exists, AND I want to change the cell color to red.
So far, here's the formula I am using. I don't think I am doing the
variance calculation correctly, and I can't figure out how to change
the cell color after I change the cell text to "1% variance exists".
=IF(sheeta!B2-sheetb!B2=ABS(1%),"1% variance exists","ok")
Any help would be greatly appreciated! Thanks.
Tom
email:
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben