Hi All,
What I'm trying to do is change the font colour of a range in a table which is dictated by a value in a cell.
Ie if cell a1 = 1 then select range b1:b5 change font to red
If cell a1 = 2 then select range b1:b10 change font to red
and so on....
any help with this would be much appreciated
Thanks
What I'm trying to do is change the font colour of a range in a table which is dictated by a value in a cell.
Ie if cell a1 = 1 then select range b1:b5 change font to red
If cell a1 = 2 then select range b1:b10 change font to red
and so on....
any help with this would be much appreciated
Thanks