View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff Reese Jeff Reese is offline
external usenet poster
 
Posts: 19
Default 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