View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peco Worker Peco Worker is offline
external usenet poster
 
Posts: 5
Default Conditional Formatting

I have a sheet that has conditional formatting that anything after a todays
date is red. What I really need is for that date that it looks at to never
change.
For Example:
If today I run it and it uses 9-25-06 and then tomorrow I run it again the
date is then 9-26-06 that it uses. How can I use a set date?