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.
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

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
54,294
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,865
Messages
5,834,066
Members
430,260
Latest member
MANICX100

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