View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Troy
 
Posts: n/a
Default Conditional Formatting

In Cell A1 I have the which for example is 1-21-06.
In Cell B1 I have the Weekday that represents, for this lets say it is
number 7.
In Cell C1 through C34 I would like the cell shaded yellow if it is Saturday
on Cell A1. How do I do this without macros, because I have no idea how to
create a macro? I have tried in the past but with no luck at all.