Conditional formating formula

D

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
 
D

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!
 
F

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
 
Top