Conditional Formatting
Pre-select the 10000 rows then add the formatting using Formula is:
Pre-select can be done by entering A1:G10000 in NameBox and hit ENTER
Note carefully where you place the $ signs.
Or Format row 1 then use the format painter to paint the rest of the rows.
Gord Dibben MS Excel MVP
On Fri, 19 Jun 2009 04:17:01 -0700, Ozgur Bilgin
wrote:
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?
|