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.
|