Good afternoon all,
A very quick question based on a generating RAG Conditional Formatting.
Essentially I am looking to have the date someone completed training turn a different colour based on how far in the past that date is. If the date is less than 4 years old, Green, if the date is less than 5 years old, Amber, and greater than 5 years old, Red.
I am able to conditionally format Green
=Today()-B2<1429
I am able to conditionally format Red
=Today()-B2>1824
I have tried the following to Conditionally format amber:
=Today()-B2<1824 - but that returns the previously formatted Green cells Amber, so wrong.
=AND((today()-b2>1429),AND(Today()-B2>1824)) - although accepted it does nothing.
I have added the sheet I was working on which i just a list of dates and their respective numeric values, this was for my benefit to see what excel what doing.
A very quick question based on a generating RAG Conditional Formatting.
Essentially I am looking to have the date someone completed training turn a different colour based on how far in the past that date is. If the date is less than 4 years old, Green, if the date is less than 5 years old, Amber, and greater than 5 years old, Red.
I am able to conditionally format Green
=Today()-B2<1429
I am able to conditionally format Red
=Today()-B2>1824
I have tried the following to Conditionally format amber:
=Today()-B2<1824 - but that returns the previously formatted Green cells Amber, so wrong.
=AND((today()-b2>1429),AND(Today()-B2>1824)) - although accepted it does nothing.
I have added the sheet I was working on which i just a list of dates and their respective numeric values, this was for my benefit to see what excel what doing.
