Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |