@v-siky-msft
Thank you for you help with this and i marked it Completed but i have made a small mistake and provide the wrong information (sorry)
Your suggestion works fine until you start a new month and it restarts the colour coding from red.
This isn't how i would like it to work.
The way i would like it to is
and this is where i made my mistake in the explanation is
If the date is (in dd/mm/yyyy)
02/06/2020 (in dd/mm/yyyy) then 'White'
03/06/2020 (in dd/mm/yyyy) then 'White'
04/06/2020 (in dd/mm/yyyy) then 'Red'
05/06/2020 (in dd/mm/yyyy) then 'Red'
06/06/2020 (in dd/mm/yyyy) then 'Green'
07/06/2020 (in dd/mm/yyyy) then 'Green'
08/06/2020 (in dd/mm/yyyy) then 'Blue'
09/06/2020 (in dd/mm/yyyy) then 'Blue'
Then the cycle starts again
10/06/2020 (in dd/mm/yyyy) then 'White'
11/06/2020 (in dd/mm/yyyy) then 'White'
12/06/2020 (in dd/mm/yyyy) then 'Red'
13/06/2020 (in dd/mm/yyyy) then 'Red'
Etc
this cycle continues and doesn't stop
Gary
ps idid try to edit the formula myself but that gos back goes wrong in the cycle by restarting at the end of the month.
Switch(Mod(Title2.Text,8),0,Blue,1,Blue,2,White,3,White,4,Red,5,Red,6,Green,7,Green)
