Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Problem
One of my conditional formatting rules is as follows:
If value of the cell is between 4.5 and 5.0 then format the cell "green". The problem is the formula calculates the result as 4.497947455 (which rounded is technically 4.5) and this cell does not format conditionally to green. Here is the formula: =(SUM(J12*$J$15)+SUM(K12*$K$15))/SUM($J$15:$K$15) Any suggestions on how to get around that? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting problem | Excel Discussion (Misc queries) | |||
Problem with conditional formatting | Excel Worksheet Functions | |||
Conditional Formatting Problem | Excel Discussion (Misc queries) | |||
Conditional formatting problem | Excel Discussion (Misc queries) |