Quick Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top