Conditional Formatting

W

Willco3

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.
 
K

Kevin B

Move to cell C2 and click FORMAT/CONDITIONAL FORMATTING in the menu.

Change condition 1 from CELL VALUE IS to FORMULA IS and in field to the
right enter the following formula if comparing for a value (substituting your
value for the 1 in the example:

=B2=1

If you want to compare to a text value, enter the text value in quotes

=B2="Message"

Then click the FORMAT command button, select the shade of red you prefer and
click OK 2 times to return to the worksheet.
 
D

David Biddulph

In C2, Conditional Formatting, Formula Is (not Cell Value Is) =C1="whichever
selection you want to shade the cell"
Choose the appropriate pattern format.
 
Top