[Solved] Format Cell Using A Style

[paulp575]

I'm sure this is a simple fix, but can't seem to get this to work.

Attachment is an extract of the entire spreadsheet.

I would like the text in columns D through F to be green if the contents of column A is a Y.

I tried using the IF formula, but can't get the name of the style into the THEN part of the formula.

Same problem if I use conditional formatting.

I don't want the text to change if column A is anything other than A.

Thanks,

[JohnSUN-Pensioner]

Maybe something like this?

And apply this format to all cells ...

[paulp575]

Maybe something like this?

FormulaForConditionalFormatting.JPG

And apply this format to all cells ...

Sorry, that didn't work.
So I tried this: Formula is $Master_List.$A6="Y" Cell style=ActiveText
That didn't work either.

I have formatted ActiveText to be LightGreen text.

Maybe a restatement of what I'm trying will help?

If the contents of the cell in column A is Y, I want columns D through F to be green text.
If the contents of the cell in column A is anything else, I want the columns D through F to remain the default text/font.

Thanks,

[JohnSUN-Pensioner]

Are you apply the formula $Master_List.$A6="Y" to all cells in the sixth row? And what is the second condition?

[paulp575]

Are you apply the formula $Master_List.$A6="Y" to all cells in the sixth row? And what is the second condition?

I am not applying the formula to all the cells in row 6 - only columns D through F.
I don't want the spreadsheet littered with a lot of green text; only the names of those who are current (indicated by a Y in column A).

There is no second condition.
I only want the text in columns D through F change to green if column A is Y. If column A is Y, then do nothing to the text in columns D through F.

Does this make it clearer? Hope so!

Thanks,

[JohnSUN-Pensioner]

I do this so...

[paulp575]

I do this so...

That worked - well almost.

My problem was I was telling the conditional formatting to use "Y" from column A when it should have been "A".

However, his suggestion only works for one row.

I need to do this for over 1,000 rows on this worksheet.

How would I change his expression so I can copy/paste to all rows of the worksheet?

It needs to be set up so when I change the contents of the cell in column A from I to A, the contents in columns D through F change automatically.

[JohnSUN-Pensioner]

OK, let's do it together...

Our task: when a letter "Y" in Column C - apply to the text in columns D:F style ActiveText with light green letters

The scheme of our task

Step by step:
Select cell D4 - the first cell in formatting range. Choose Format - Conditional Formatting

Carefully! Address in the formula!

Address in the formula is $C4 - always column C and current (forth) row!
ОК.
Copy cell D4 to the clipboard. In the usual way: Ctrl+Insert or Ctrl+C or button "Copy" on the toolbar...
Press Ctrl+Shift+End - select range from current cell D4 to end of data. In "Name Box" (top left) you can see address of selected range - D4:F27. Change it by typing some zeros at end (D4:F2700 or D4:F27000 or D4:F270000) and press Enter. Selection will be resize.
Now right click and select Paste Special from the menu. Of all the options of Paste Special - only the format needed...

Options of Paste Special

ОК.
In the condition of formatting everywhere will be column C and different rows
That's all, folks!