View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Geoff Murley Geoff Murley is offline
external usenet poster
 
Posts: 4
Default Conditional Formatting

I have a sheet with n columns and n rows.

For each row I would like to highlight, in yellow, the 6
cells with the highest values in that row.

I can't think of a way of doing this using the normal
conditional formatting. Is there a VBA solution?