View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Joe Joe is offline
external usenet poster
 
Posts: 38
Default can I configure Conditional formatting to change color weekly?

On Feb 21, 2:52 pm, Toppers wrote:
Try:

Select your cell and in CF:

FormulaIs: =weekday(Today(),2)=1 and set colour



Thanks to both of you, so am I to assume that if I want to change the
day to Wednesday it would be =weekday(Today(),4)=1