cell formatting

K

kraway

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.
 
C

Chip Smith

may want to look at conditional formatting...that will most likely help you
in this case of changing cell colors and any font changes
 
N

Nikki

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$1>0

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
 
Top