I have a drop down box (in cell 1) that people have to choose an option for
(out of approx 20 items) - I want to turn the cell next to it (C2) red if one
particular option is selected from the drop down menu in C1 - this will act
as a reminder that they need to select another option from (C2) in order to
proceed - help is needed. Thanks.
--
DWillcox