Forum Discussion
Highlight every 10th row except if value in Y is >10%
I need to highlight every 10th row in a file, except if the value in column Y is 10% or more. I can highlight every 10th row using =MOD(ROW(),10)=0 I can easily highlight rows where the value...
Simply multiplying the two conditions together gives the numerical equivalent of AND
= (MOD(ROW(),10)=0) * (Y7 >= 10%)Mind you, I would have expected AND to work. Perhaps I should try it.
- Thanks Peter. I'll give that a go too.
