Mar 18 2024 07:53 AM
Hello All,
I'm trying to set up my conditional formatting so the contents of column A decide how often it needs to be reviewed.
For example, if a cell in column A is "high"I want the cell in B to highlight if the date is over 30 days old.
Then will be doing a different amount for medium and low.
This is how I currently have the formula which isn't working. It is highlighting all the cells in B that are over 30 days. I assume as the top cell is "high"
Any assistance with this would be greatly appreciated. Thanks in advance!
Mar 18 2024 08:02 AM