View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default Conditional format row based on percentile

Sounds like you have v2007, since I don't recognize all those
features. But you should be able to select all of the cells you want
formatted in one row (so A2:N2 or similar), then do your conditional
format, using absolute references to Column K. Then you should be able
to copy the formats down the rows without trouble.