Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Can I use conditional formatting ?
Posted by T Benjamin on September 17, 2001 6:09 PM
How can I use Conditional Formatting to shade every cell gray that contains "Sunday" in a range eg. a1:a50
Re: Can I use conditional formatting ?
Posted by Tom Urtis on September 17, 2001 6:53 PM
Hilite the cells (in your case A1:A50), and click Format > Conditional Formatting. In Condition 1's first drop down box, choose "Cell Value Is". In the next field choose "equal to", and in the third field type ="Sunday". Then click the Format button, click the Patterns tab, and choose the gray color you want to have those cells shaded.
Tom Urtis
Re: Can I use conditional formatting ?
Posted by T Benjamin on September 17, 2001 10:33 PM
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.