Frank Freese
asked on
Conditional formatting problem
Folks,
In the attahced workbook I was working on duplicating a conditional formatting problem in using the WEEKNUM and MOD functions to shade every other Tuesday and it is not working.
everysecondtuesday.xlsm
In the attahced workbook I was working on duplicating a conditional formatting problem in using the WEEKNUM and MOD functions to shade every other Tuesday and it is not working.
everysecondtuesday.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I suppose you are right, you could also simplify to:
=AND(WEEKDAY($A2)=3,MOD($C 2,2)=1)
where column C contains the weeknumber.
=AND(WEEKDAY($A2)=3,MOD($C
where column C contains the weeknumber.
ASKER
I'll try that also.
The solution given was =AND(WEEKNUM($A3)=4,MOD($C 3,2)<>0
The solution given was =AND(WEEKNUM($A3)=4,MOD($C
ASKER
The second solution you offered worked also.
Thanks
Thanks
ASKER
Thank you so much