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?
|