How do I change fill color in excel based on data in the cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a check list. What I want is when a task is not done,
ie blank, the cell fill color is yellow. When it is done, the cell color goes
back to none. This is to help make the spreadsheet more visible in accordance
to company policies. Any ideas?
 
Jason

Conditional Formatting from the Format menu.

Formula is =ISBLANK(cellref)

Pick a color and OK your way out.


Gord Dibben Excel MVP

On Thu, 29 Sep 2005 08:36:10 -0700, "Jason Southco" <Jason
 

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

Function for summing or counting cells based on a specified fill color 2
Excel Macro to automatically go to the right of the last colored cell 0
add value of cells based on the formatted fill color 3
How to Color a Cell Based on a Range of Cells with Colors 1
Excel VBA 1
Fill color 2
Changing Cell Color Based on Value 2
how do I lock the fill color in a cell 1

Back
Top