How do I write this Conditional Formatting

[Jack-P-Winner]

I want to highlight the following 100 rows with all the UUDDU to be yellow and want to know how to write the rule using conditional formatting

UUDDU

 

[Smallman]

Hi Jack

The formula for the conditional formatting looks like the following.

=AND($A2="U",$B2="D",$C2="D",$D2="U",$E2="D")

THe file outlines the technique.

Take care

Smallman

 

[Jack-P-Winner]

Smallman,

Can you look at this and tell me what I am doing wrong. I have a series of different rules I will be needing to write to cover a different letter sequesnces and I am not doing something correctly. If you will notice I have writern the rule for row 4 and it carries it all the across row 4 and not just the DUDDU I am trying to shade.

I wrote: =AND($A4="D",$B4="U",$C4="D",$D4="D",$E4="U") for DUDDU which is on row 4 and asking the rule to shade it green


Thank you!!!

 

[Steve S.]

I think that you will need to write a separate formula for each sequence of letters. What you have written asks Excel to shade in any cell in the selection when A4 = D, B4 = U,...E4=U is true for that row. I re-wrote your formula for each group of cells.

 

[bobhc]

If you look in the Manage Rules you will see that you have set this rule to include the cells it does, it is doing as you asked it to do.

=$A$4:$X$47....Applies to should be =$A3:$E4


.

 

[Jack-P-Winner]

Much appreciated guys!!!!