Hi Gregory
you can use conditional formatting for this as long as you don't have more
than 3 conditions. If you do you need to either check out other options
some are mentioned at the end of this email.
To apply conditional formatting:
1. select the cell(s)
2. choose format / conditional formatting from the menu
3. choose
cell value is
4. choose
equal to
5. type
run
6. click on FORMAT - set the formatting options that you want - font
colour is on the font tab, background colours on the patterns tab.
7. click OK
8. to add another condition click ADD and repeat steps 3 through 7
when you have finished click OK to return to the workbook.
Options for more than 3 conditional formats:
- John McGimpsey has an article on doing up to 6
www.mcgimpsey.com/excel/conditional6.html
- Bob Phillips & Frank Kabel have developed an excel add-in
www.xldynamic.com/source/xld.CFPlus.Downlaod.html
- or you can use some code in the worksheet_change event to do this too ..
if you're interested in this option and it isn't as difficult as it sounds
please post back.
Cheers
JulieD
