Conditional formatting Question
Hi I'm trying to highlight cells based on two premises :
If 90 days of hire have passed and cell value is between X & X highlight red.
If less than 90 days of hire and cell value between X and X highlight Blue.
Is there a way to do this?
|