Applying Conditional formatting with 3 criterias

Hi,

I have a calendar which consist the dates from 1st Jul to 31st July. Here in in this i need to highlight the dates from 20th Jul to 31st July with the below 3 conditions by using conditional format

1. All working days comes from 20th to 31st Jul to be highlighted with Blue color except last working day.
2. Last working day to be highlighted with Green
3. Weekend dates to be highlighted with RED.

it would be helpful if you could please help me with the formula. THanks in advance.....

Please see yellow banner at top of page on how to attach a sample workbook.

i am not able to attach the samples as its restricted from my official system.

With dates in A1 to AE

T1=20/7/2021

=T1=EOMONTH(T1,0) Green

=WEEKDAY(T1,2)<6 Blue

=WEEKDAY(T1,2)>=6 Red

Its perfectly works as per my requirement. Thanks a lot...

Hi,

Sorry for troubling you again, i have done some alteration in this formula, out of 3 conditions last condition is not working

I have the below 3 formulas in my conditional formatting. Can you please check and suggest why the last one is not giving result.

1.=AND(D$4>=WORKDAY($AY$19,1)+1,WEEKDAY(D$4,2)<6) - Blue Color - This is working fine.
2.=IF(D$4>$AX$11+1,OR(WEEKDAY(D$4)=7,WEEKDAY(D$4)=1)) Red Color - This is working fine
3 =T1=WORKDAY(EOMONTH(T1,0)+1,-1) Green - But this is the only formula not working....

New rule for GRREN

=T1=WORKDAY(EOMONTH(T1,0)+1,-1)

Thanks for sharing this....But this formula is directly applied from the date 20th....instead can we apply this from the first date of the month and result can highlight from 20th onwards??

Use

=AND(A1>=DATE(2021,7,20),WEEKDAY(A1,2)>=6) Red

Similar for Blue

And change CF range to be A!:AE

Done...Now its fine....Thanks a lot.