Hi
I am trying to figure out a formla so that if the cell for example V2 = True then the row below 3 in this case is highlighted blue.
There can be up to 500 rows in total and want all rows below the word true to be highlighted in blue if that makes sense?
does anyone have any suggestions?
Many thanks in advance?!
Dan
I am trying to figure out a formla so that if the cell for example V2 = True then the row below 3 in this case is highlighted blue.
There can be up to 500 rows in total and want all rows below the word true to be highlighted in blue if that makes sense?
does anyone have any suggestions?
Many thanks in advance?!
Dan