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.
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.