Hi everyone,
I have conditional formatting on B8:H8 based on contents of row 9.
So in B8 Formula is =ISNUMBER($B$9)
That works well but other users may add rows and copy formatting. Wondering if it's possible to add offset to the formula so that CF in each row is based on the cell directly below it.
If anyone could help that would be brilliant.
Cheers
Diddy
Bookmarks