Quick Question
 

I am creating a spreadsheet for work to track when employees have completed
training. When the main date changes and the date on the employee don't
match I want the fill to self generate to red and green when training is
accomplished. Is this possible. Don't want a value like with a if statement
but just a fill to highlight it.

Quick Question
 

Hi Kory,

I'm not completely clear about what you want precisely but it sounds like
conditional formatting will do what you want and here are a couple of example
to get you going. To enter these select cell (in this case A1)

Format|Conditional Formatting - Select formula is from the dropdown and
enter these formula and select a colour

=A1 < TODAY()-1
Changes cell colour if it is earlier than today

=A1 < TODAY()-1
Changes cell colour if it is later than today

=A1 < D1
Changes cell colour if it is earlier than the date in D1

etc

Mike

"Kory" wrote:

I am creating a spreadsheet for work to track when employees have completed
training. When the main date changes and the date on the employee don't
match I want the fill to self generate to red and green when training is
accomplished. Is this possible. Don't want a value like with a if statement
but just a fill to highlight it.