ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Limit to Conditional Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/139569-limit-conditional-formatting.html)

Jeff Reese

Limit to Conditional Formatting
 
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


All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com