Hi all
How would I go about being able to colur both the column and row in a block of cells B2:J10 it the number matches what's in A1, there will be multiple numbers so I'd need all relevant cols and rows to be coloured, but if A1 is clear then no colour is needed.
Cheers
How would I go about being able to colur both the column and row in a block of cells B2:J10 it the number matches what's in A1, there will be multiple numbers so I'd need all relevant cols and rows to be coloured, but if A1 is clear then no colour is needed.
Cheers