conditional formatting from combo box

[tjb]

When the user selects a certain combination from two
different combo boxes, I want to use conditional
formatting to gray out a few cells.

I'm currently using VBA to do this but am running into
some issues where users have different versions of Excel
and the code written for Excel2003 doesn't work for
Excel2000.

Anyhow, any ideas on using conditional formatting with
data from combo boxes? Thanks!

 

[Debra Dalgleish]

Link the combo boxes to cells on the worksheet, and base the conditional
formatting on those cells.