cell formatting
 

I need a little help. I want to change the fill color of a cell based on the
date of a different cell being more than 10 days past but I only want to
change it if the cell is empty.

Any help? Thank you.

cell formatting
 

may want to look at conditional formatting...that will most likely help you
in this case of changing cell colors and any font changes
--
--Chip Smith--
MVP Wannabe :)


"kraway" wrote:

I need a little help. I want to change the fill color of a cell based on the
date of a different cell being more than 10 days past but I only want to
change it if the cell is empty.

Any help? Thank you.

cell formatting
 

if your refrence cell is C1
the cell you want to change color is B1
go to tools---Conditional Formatting---formula is--type =$B$1-$C$10

click on format ---go to pattern--choose a color---OK

now if date in B1 is more than 10 days in C1 the cell changes color to the
pattern you selected.

Nikki


"kraway" wrote:

I need a little help. I want to change the fill color of a cell based on the
date of a different cell being more than 10 days past but I only want to
change it if the cell is empty.

Any help? Thank you.