View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paul Hyett[_2_] Paul Hyett[_2_] is offline
external usenet poster
 
Posts: 24
Default Help requested for conditional formatting

I would like to set up a conditional format whereby if today's date
minus [date in referenced cell] was greater than a certain number, then
the fill colour of the cell would be changed.

I've tried experimenting with setting this up, but just don't seem to be
able to hit the right syntax.

Any assistance would be much appreciated.
--
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)