Thread: Apply green to current date, red to 2 days overdue and none if pai
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vpschas vpschas is offline
external usenet poster
  
Posts: 9
Default Apply green to current date, red to 2 days overdue and none if pai
Hi,

I'd like to find out how to format an Excel 2002 worksheet to highlight the
current date (in column A) in green and then if it is overdue by more than 2
days to change to red but if the amount has been paid in full (shown in
column F) to revert back to white, please.

Many thanks,
vpschas
(UK)


Reply With QuoteReply With Quote