Cell Fill Color

  • Thread starter Thread starter manickel
  • Start date Start date
M

manickel

What about using a conditional format formula.

If the cell value is in a certain list then turn the cell yellow...

can that be done
 
Hi
this is possible. Assume your cell to color is cell B1 and your list of
values is in X1:X10 then enter the following formula in the conditional
format dialog:
=COUNTIF($X$1:$X$10,B1)
and choose your yellow format
 
Back
Top