Conditional Formatting --- copying to multiple rows

A

akunce

I have a small worksheet, columns A-F are information about an item.
Column G will have a value of "Yes" or "No" (or "TRUE" or "FALSE").

If Column G, row 2 is "TRUE" then the format of the font in that cell
should be a Bold Red, and the font in the cells A2-F2 should also turn
red. If "FALSE" then the text remains black.

I can Copy and Paste Special the Format, but then rows 3-2500 are
still tied to G2. I can't seem to get the conditional formatting to
automatically change the the correspond row/column G.

Does that make sense?

Basically, when there's an entry in Column G, I want the text of the
whole row to turn red, and I can't figure out a quick copy/paste for
the entire workbook.
 
J

John McGhie

You need to use the Format Painter to copy conditional formatting.

Study the help topic "Change conditional formatting" really closely.

Cheers

I have a small worksheet, columns A-F are information about an item.
Column G will have a value of "Yes" or "No" (or "TRUE" or "FALSE").

If Column G, row 2 is "TRUE" then the format of the font in that cell
should be a Bold Red, and the font in the cells A2-F2 should also turn
red. If "FALSE" then the text remains black.

I can Copy and Paste Special the Format, but then rows 3-2500 are
still tied to G2. I can't seem to get the conditional formatting to
automatically change the the correspond row/column G.

Does that make sense?

Basically, when there's an entry in Column G, I want the text of the
whole row to turn red, and I can't figure out a quick copy/paste for
the entire workbook.

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
 
A

akunce

I read the Help very carefully, I'm still not able to change the cell
references unless I Copy, Paste Special-Format, then change the
reference cell in the G column manually.

Perhaps I have the G column wrong?

I have the conditional formatting for that as:

Cell value is equal to TRUE
(which will change the font in that cell red and bold)

Then I want columns A-F in the rows to change to red also if the
corresponding G cell = TRUE.

So there's something in error here. What it is, ain't exactly clear.
 
A

akunce

Ah! I figured it out by searching the forum with better keywords and
reading a LOT of discussions.

The conditional format should be =$G2=TRUE for row 2 (row 1 is used
for column header.)

Then copy and paste the formula to the other rows, up to row 1551 on
my spreadsheet, and the row number fills in automatically, so the last
row has the formula =$G1551=TRUE.

I know most of you are thinking "DUH!" and you'd be right. But I'm not
all Excel-efficient yet.

So this forum helped me out! This and the MS Word for Mac are the best
help forums around!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top