Formatting

  • Thread starter Thread starter Terry Boat
  • Start date Start date
T

Terry Boat

I need help with the below:

If the value in cell a1 has a corresponding value in Tabel c1:h15, then can
I change the color of cell a1 to blue?

-
Terry
 
click on a1 and:
Format > Conditional Formatting > Formula Is > =COUNTIF(C1:H15,A1)>0 and
pick the color
 
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

Change Color of cell 3
Blanks ("") by Formula 2
Excel 2007: cell shading (not conditional formatting) 1
Excel Need Countifs Formula Help 0
Conditional Formatting 3
What is wrong with this simple formula? 6
Excel Formatting 4
Copy a cell from another worksheet and create a line wrap 1

Back
Top