Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
conditional formatting
Posted by Matt Frost on July 12, 1999 5:41 PM
Can anyone give me a good example ( not like the excel help one) that
will explain where you could use the "formula is" option in
regards to conditional formatting.
thanks.
Re: conditional formatting
Posted by Peter Glass on September 15, 1999 5:47 PM
Matt,
I used this function recently. I have 12 columns of figures (Starting Column B), for the 12 months of the year. In row A, the columns are numbered 1 to 12. If the months were in the future, I wanted to paint them yellow. The number of the current month was in cell A1. So in all the cells I wanted painted, I used "Conditional Formatting" - "Formula Is" then "=b$1>$A$1". Copy this to all the cells. Therefore, if the figure in A1 is the last completed month, all the future months become yellow.
Regards,
Peter
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.