Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting bug?
curious to know what might cause this...
=MIN($F$10:$F$17,$F$19:$F$22) this is the formula i am using for a conditional format (the min value is highlighted in red)...i pasted special formats for F10:F23. cell F18 (not in the range specified in the formula above) is equal to cell F16 (in the range specified in the formula) which happens to be the minimum value, and for some reason cell F18 is also highlighting along with F16. oddly, if i change the value for cell F18 to a number lower than F16, the highlighting in cell F18 disappears and F16 remains highlighted (as it should). is this a bug in excel? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |