Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1871617%22%20slang%3D%22en-US%22%3EConditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1871617%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20Excel%20to%20fill%20cell%20B2%20with%20red%20fill%20if%20cells%20C2%20or%20D2%20meet%20a%20particular%20condition.%20Any%20help%20with%20this%20would%20be%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1871617%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1871727%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1871727%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F275274%22%20target%3D%22_blank%22%3E%40allen8106%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20B2.%3C%2FP%3E%0A%3CP%3EOn%20the%20Home%20tab%20of%20the%20ribbon%2C%20click%20Conditional%20Formatting%20%26gt%3B%20New%20Rule...%3C%2FP%3E%0A%3CP%3ESelect%20'Use%20a%20formula%20to%20determine%20which%20cells%20to%20format'.%3C%2FP%3E%0A%3CP%3EEnter%20a%20formula%20like%20this%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DOR(C2%3D%22This%22%2CD2%3D%22That%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eusing%20your%20specific%20requirements%20of%20course.%3C%2FP%3E%0A%3CP%3EClick%20Format...%3C%2FP%3E%0A%3CP%3EActivate%20the%20Fill%20tab.%3C%2FP%3E%0A%3CP%3ESelect%20red.%3C%2FP%3E%0A%3CP%3EClick%20OK%2C%20then%20click%20OK%20again.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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.