I have set up the condition that if, for instance, cell G7 has the text
"Yes", then all the text in the other cells in row G changes from red font
colour to black.
How can I copy this conditional formatting to all rows in the worksheet
without having to change the G7 to H7, I7 and so on manually?


tia
--
Jock Waddington