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

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?
 
G

Gord Dibben

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
How to Color a Cell Based on a Range of Cells with Colors 1
add value of cells based on the formatted fill color 3
How can I automatically color a cell based upon a condition being 4
Changing Cell Color Based on Value 2
how do I lock the fill color in a cell 1
color fill cells based on IF function or formula 1
Cell Color Recognition and Summing of Data Within a Specified Colo 1

Top