Conditional Formatting
Hello,
My sheet is 10.000 row so It's possible to do this operation manually. Is it
possible to copy first row property to all rows?
Regards,
"Sean Timmons" wrote:
Highlight A - G.
Conditional Formatting...
Pick:
Formula Is
enter:
=$G1="K"
Format, pick your fonts.
Same for the others.
The key is to retain the $ before the G.
"Philip Drury" wrote:
I want to change the colour of cells A1:G1 if the value of G1 is K (make the
row green), U (make the row amber) or S (make the row red). Really want this
to apply to each row below as the relevant G value is input.
Does that make sense?
|