auto date: cond. format Question

N

nastech

have code for auto date entered to cells, but need to tweak conditional
format to change color for new item today, tried "=" sign, <now(), but can't
get. using:

=IF(AF9="","",(AF9+AF$7)<TODAY()) to get x day old change color

1. trying to flip to get to change color if new today
2. is there a way to exclude weekends (sat/sun) in x days old, for
conditional format, so don't have to use absolute cell, to switch from 1 to 3
days?.

thanks in advance.
 

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

Top