Conditional formatting

[mady007]

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.

 

[rondeondo]

Hi mady
Do you want the day of the week to be part of the condition? So the condition will be something like

=or(and(weekday(today())=2,B2>=5),and(weekday(today())>=2,B2>=10)

Choose your days. The weekday function allows you to specify which day of the week to c out from.