Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Conditional formatting with multiple criteria

0

If cell A2 shows TRUE and cell B2 = cell B1 then highlight cell C2 red.

Answer
Discuss

Answers

0
Selected Answer

Use this formula:

=AND(A2=TRUE,B1=B2)

Select cell C2 and go to:

Conditional formatting > New Rule > Use a formula to determine which cells to format > and input the above formula and then click the Format button in that window to choose how to format the cell when the formula evaluates to TRUE.

Discuss
0

You can do that with conditional formatting. Look up Excel help for step-by-step instructions.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login