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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Excel Macro to automatically go to the right of the last colored cell 0
Cell Fill Color 1
Conditional Formatting 1
SHADING FOR MULTIPLE TEXT ENTRIES 7
Help, please, with unwanted fill color 3
Cell Count 2
how do i set more than three conditions in condition formatting? 1

Back
Top