I need a conditional formatting formula.
I want the cell to highlighted Green when each time file is opened and the people updates the leads actioned column.
For example. Starting on Sat the action lead should be 5 or more for the cell be green.
Skipping sunday, on Monday the leads count be 10 in order for the cell to be green. Basically there are 30 leads per week.
I need help the conditional formatting formula please.
I want the cell to highlighted Green when each time file is opened and the people updates the leads actioned column.
For example. Starting on Sat the action lead should be 5 or more for the cell be green.
Skipping sunday, on Monday the leads count be 10 in order for the cell to be green. Basically there are 30 leads per week.
I need help the conditional formatting formula please.