Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting is not working...
This is the formula I am using: =COUNTIF(R16:R44,"Y")/COUNTA(R16:R44) The conditional formatting I am using works on most cells but a couple are not working i.e. [/indent]0 to .7 = red [/indent].71 to .8 = yellow [/indent].81 above = green A couple cells are not formatted - I am thinking it has to do w/the cell being formatted for % vs. decimal pt. and maybe the decimal is out by alot. Any suggestions?... -- tmerton ------------------------------------------------------------------------ tmerton's Profile: http://www.excelforum.com/member.php...o&userid=32574 View this thread: http://www.excelforum.com/showthread...hreadid=523771 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting is not working...
Please stick with the original newsgroup thread
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Formatting | Excel Worksheet Functions | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions | |||
Conditional Formatting Not Working Consistently | Excel Discussion (Misc queries) | |||
conditional formatting conflict? | Excel Worksheet Functions |