Conditional format

[MPXJOHN]

I have the following conditional format under "Use a formula to determine which cells to format". "=SUBSTITUTE(A1," ","" )= $D2 & E$1". Instead of looking at just "A1", I would like to look at the entire "A" column. Is this possible? I have tried using "A1:A10000" but this is not working. Thanks.

[dogberry]

Hi

You could use A:A in your formula but referring to entire columns tends to slow things up

Chris

[Kevin UK]

Hi MPXJOHN

Try: =SUBSTITUTE(A1," ","" )= $D$2 & $E$1

[MPXJOHN]

I have tried both posts #2 & #3 and neither work. Post #3 works just like my original formula. It still won't look at the entire column.

[Ace_XL]

try this rule in CF

Please Login or Register  to view this content.

[Kevin UK]

Hi MPXJOHN

See the attached file.