Identify rows if in the row one of the cells within a range is colored
Thanks (as usual),
Works as wished !!. Allways amazing how you can fix a problem :)
It taste to a bit more (if you like).
The next step step is to hide the columns in the range F till BZ if in the rows 3 (not 2 but 3) till last of that column is no colored cell.
After this rule I have a quick view on only the colored rows with the unique rownrs, but also only the columns that have a marked cell.
Makes life easier.
regards, Johan
|