Nov 10 2020 05:28 AM
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.
Nov 10 2020 05:46 AM
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.