conditional formatting?
1. Select cells B2:M2
2. From the menu bar: Format, Conditional Formatting
3. Formula Is: =OR($B2= "Sat", $B2="Sun")
4. Patterns: Select the color you want, then click OK
5. Click OK
6. Drag down the sheet for as many rows as needed..
"xp" wrote in message
...
If any cell in column "B" contains either "Sat" or "Sun" then I want those
rows from columns "B" to "M" to be shaded.
Can this be done using conditional formatting, or do I need to run a
macro?
If possible with conditional formatting, how is it done?
Thanks.
|