| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting gliche.
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. Any suggestions on how to get around that? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting gliche.
Hi,
It would have helped to see your CF formula but maybe this =AND(ROUND(A1,2)=4.5,ROUND(A1,2)<=5) Mike "mrogozinski" wrote: 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. Any suggestions on how to get around that? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting gliche.
Here is the formula:
=(SUM(J12*$J$15)+SUM(K12*$K$15))/SUM($J$15:$K$15) "Mike H" wrote: Hi, It would have helped to see your CF formula but maybe this =AND(ROUND(A1,2)=4.5,ROUND(A1,2)<=5) Mike "mrogozinski" wrote: 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. Any suggestions on how to get around that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Printing gliche | Charts and Charting in Excel | |||
| HAVING A FORMULA GLICHE??? | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
