Conditional Formatting with Multiple Conditions

[mikec1982]

I need a conditional formatting formula for meeting two conditions.

Sheet 1:

Course Name	Course Enrollment #
English	20

Sheet 2:

Course Name	Course Max
English	18

I am seeking a conditional formatting formula that formats Sheet1 B2 if (Sheet1 A2 = Sheet2 A:A) AND if (Sheet 1 B2 > Sheet 2 B:B).

Any assistance is appreciated.

 

[SanjayGMusafir]

We had similar question on this forum. Check this for solution -

conditional format to change color

I have a calendar that takes info from another sheet. On the info sheet, column "B" changes to green if column "I" has a date. I would like to replicate that on the calendar if possible and I'm so stuck. The calendar is LIVE and changes every month. If you can help me create the conditional...

www.mrexcel.com