conditional formatting help

[brianaclark1967]

Hi all,

Need some help with conditional formatting please.

I want cells in column D to change colour when the adjacent cell i row C has one of four words in it.

For example:

Each cell in row C will have either, Debit Card, Credit Card, PayPal or Cash in it.
When one of these words appear I want the cell in the same row, column D to turn green.

Also if the cell in column C has other words in it (apart from the four above) ie: peoples names (Fred, Bob etc), can cells in column C turn Red

Any help (and sample sheet) would be greatly appreciated.

Regards

Brian

 

[Hui]

Select D2:D100 or what ever your range is
Goto Conditional Formatting
New Rule
Use a Formula
=OR(C2="Debit Card",C2="Credit Card",C2="PayPal",C2="Cash")
Set the formatting
Apply

 

[brianaclark1967]

Select D2:D100 or what ever your range is
Goto Conditional Formatting
New Rule
Use a Formula
=OR(C2="Debit Card",C2="Credit Card",C2="PayPal",C2="Cash")
Set the formatting
Apply

Hi Hui,

Thank you so much for your help.

It's really appreciated

Regards

Brian