Excel conditional format question

  Chris the Ancient 18:03 21 Feb 2007
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 2007

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 2007

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.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

The secrets of creating gory VFX

How to update iOS on iPhone or iPad

WhatsApp : comment lire vos messages sans que l’expéditeur le sache