Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have data that is in three columns by ~3000 rows.
I want to apply conditional formatting using icon sets such that for each row it looks at the three values and displays the appropriate icon. The problem: When I highlight all cells and apply conditional formatting - it doesn't take. The icons don't appear. However... If I select a smaller chunk, say 100 rows of data, it does work. Does anyone know if there's a limit to the number of cells conditional formatting can be applied to at once (or some other reason for this behavior)? Thanks. -- Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting - Getting pass the 3 condition limit | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) |