Need help with conditional format or VBA code

DV8

New Member
Joined
Sep 21, 2005
Messages
6
I have a training spreadsheet (to keep track of employees training). I am trying to use conditional formatting to have the cell turn green if the employee has received training in the past year, red if the time has gone past a year, and yellow if the word "training" is entered.

I can get the green condition and the red condition but I cannot get the third condition. If the word "trained" is entered or the cell is blank it will still be green.

Here is an example of what I am trying to use, like I said the first two conditions work:

Condition 1: Formula Is =$A$1<TODAY()-365

Condition 2: Formula Is =$A$1 >TODAY()-365

Conditon 3: Formula Is =$A$1="training"

If I cannot use conditional formatting could I use VBA code instead, if so please help, because I am clueless.
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

DV8

New Member
Joined
Sep 21, 2005
Messages
6
Could it be that simple? I will try. I don't know why Condition 1 above does not read right above, it should be:

=$A$1<TODAY()-365
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,926
Office Version
  1. 365
Platform
  1. Windows
I don't know why Condition 1 above does not read right above, it should be:...
If you have that problem in a post, try leaving a space around the inequality sign like this:
=$A$1 < TODAY()-365
 

Watch MrExcel Video

Forum statistics

Threads
1,122,564
Messages
5,596,875
Members
414,106
Latest member
Tigretto

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top