Forum Discussion

adubs22's avatar
adubs22
Copper Contributor
Mar 18, 2024

Conditional Formatting Help Please!

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!

 

 

 

Resources