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: |
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 |