Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting - 3 Rules - Excel 2000
Hi, I am using Excel 2000 and need to use Conditional Formatting to visually
represent areas of concern. I have one worksheet holding the core data, linked to a 2nd sheet which provides a summary where the formatting is used. I am using 3 colours to highlight data according to their value, Green, Yellow, Red, with the following settings: Green: 90 or above Yellow: Between 60 and 90 Red: Between 1 and 60 So if 91 is in cell a1, the cell automatically changes to Green and so forth. The conditional formatting works fine when data is entered directly into the cell. However, when it is linked and the linked cell has no data in it, it automatically turns Green when the formatting is applied. When i put zero in on the data sheet, it comes up with a #DIV/0! error msg. I have used the following to suppress the error msg so nothing comes up, but it fails to correct it. =IF('sheet2!F4="","",'sheet 2'!F3/'sheet2'!F4) So if cell 'sheet2!F4 is blank, then nothing is input, otherwise process F3/F4. To me, it looks like a simple process, but Excel doesnt like it. If someone could shine some light on this, that would be much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create 5 Conditional Formatting rules in Excel 2003? | Excel Discussion (Misc queries) | |||
Conditional Formatting Rules Manager Excel 2007 | Excel Worksheet Functions | |||
Suggestion: Excel 2007- New Conditional Formatting Rules and Optio | Excel Discussion (Misc queries) | |||
More than 3 rules of conditional formatting | Excel Discussion (Misc queries) | |||
I need 5 conditional formatting rules-excel only allows 3 | Excel Discussion (Misc queries) |