Excel conditional format question

  Chris the Ancient 18:03 21 Feb 07
Locked

I'm old and I'm tired and my brain has turned to porridge (some might say that is an improvement!)

I need a simple (?) conditional format in my message log. I have some rows of data, and I use column E for a cleared flag (a "Y" - without quotes) to show that the action has been cleared.

I would like the accompanying cells in Columns A-D to be one colour if there is a "Y" or a different colour if there isn't.

I know I will kick myself when I see the answer; but I am old and I'm tired...

CtA

  VoG II 18:11 21 Feb 07

Select A1:D1, Format > Conditional formatting.

On the drop-down select Formula Is:

In the Formula box enter:

=$E1="Y"

Click the Format button, choose a format, OK.

Click the Add button

On the drop-down select Formula Is:

In the Formula box enter:

=$E1<>"Y"

Click the Format button, choose a format, OK twice.

Select A1:D1, click the Format Painter button, then drag down as far down A:D as necessary.

  Chris the Ancient 18:34 21 Feb 07

Of course!

Some old, tired person was trying to write a 'real' formula. :o((

We'll miss you when that foot's better and we don't get instant responses ;o)

As always, many thanks for the help.

CtA

This thread is now locked and can not be replied to.

What is ransomware and how do I protect my PC from WannaCry?

Disney layout supervisor Rob Dressel on the challenges of visualising Moana

Siri vs Google Assistant