Look at Conditional Formatting

Select the cells in columns D,E,F & G and then

Format/Conditional Format

Select Formula Is and use

=$C2="John"

HTH

PC


"Bruise" wrote in message ...
I am trying to set up a code to change the cell color and font color depending on the entry in a particular cell.

Example:

If C2 is "John", then D2, E2, F2, G2 cell colors change to red with white, bold lettering.

If C2 is anything but "John", the D2, E2, F2, G2 cell colors stay normal, as does the font.

Can anyone help me with this?