I have followed the advice in the thread: http://www.excelforum.com/excel-gene...html?p=1899924 but I wondered if anyone knows what formula to enter so that I can apply the above principle to a whole column?
I used the formula to get a row to change colour when a particular cell is entered. So, when something is entered into A1, the cell changes colour. And I can get the row to change colour by copying the format of cell A1 across the whole row.
=$a$1<>""
What I need to do, though, is get the same rule to apply to the whole column A so, for e.g. when I enter text in cell A1, the whole of row 1 will change colour and when I enter text in cell A2, I want row 2 to change colour, A3 for the whole of row 3 etc. etc. How can I do this without having to create a new rule for each row?
Thanks!
Bookmarks