Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
How to change cell colors based on an IF statement formula?
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: |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
How to change cell colors based on an IF statement formula?
=IF(Abs(sheeta!B2-sheetb!B2)=1%,"1% variance exists","ok")
Select the cell and do format=Conditional Formatting select cell value is equal to and in the box put "1% variance exists" with no double quotes. Select the format button and under patterns, select red. OK out. Regards, Tom Ogilvy "Tom Woolman" wrote in message om... 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: |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically change cell colors based on date in cell | Excel Discussion (Misc queries) | |||
How to have row color change based on one cell to 4 colors | Excel Discussion (Misc queries) | |||
How do I change row text colors in Excel based on formula? | Excel Discussion (Misc queries) | |||
Can an excel cell automatically change fill colors based on values | Excel Discussion (Misc queries) | |||
Is it possible to change colors of cells based on value in cell (. | Excel Worksheet Functions |