Conditional Formatting

Copper Contributor

I would like Excel to fill cell B2 with red fill if cells C2 or D2 meet a particular condition. Any help with this would be appreciated.

2 Replies

@allen8106 

Select B2.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter a formula like this:

 

=OR(C2="This",D2="That")

 

using your specific requirements of course.

Click Format...

Activate the Fill tab.

Select red.

Click OK, then click OK again.

@Hans Vogelaar  Worked perfectly, thank you a ton.