Conditional formating formula

  • Thread starter Thread starter DKerr
  • Start date Start date
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
 
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!
 
Hi
if your current cell is B1 enter the following formula in the
conditional format dialog:
=COUNTIF($D$1:$D$20,B1)>0
 
Back
Top