Conditional formating formula

[DKerr]

Hello,

I'm not sure if it is possible but I would like to use conditiona
formating to check the value of the cell and if it matches with one o
20 values in d1 to d20, then change the cell format. Currently I ca
set my conditional format formula to check one cell in the formula.
Anyone got any ideas

 

[Domenic]

Hi,

Assuming that A1 contains your value for conditional formatting...

1) Select A1
2) Format > Conditional Formatting > Formula Is
=COUNTIF($D$1:$D$20,$A$1)>0
3) Choose your formatting
4) Click Ok

Hope this helps!

 

[Frank Kabel]

Hi
if your current cell is B1 enter the following formula in the
conditional format dialog:
=COUNTIF($D$1:$D$20,B1)>0

 

[DKerr]

Thanks thats a massive help