View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wx4usa wx4usa is offline
external usenet poster
 
Posts: 122
Default Conditional format in excel 2003 based on another cell?

Is there a way to conditionally format a cell based on a date in
another cell?

In other words, cells A1:A10 contain data. C15 contains a date. If the
date is in the past, can I change the formatting in cells A1:A10? Or
any other cells for that matter?