Apply conditional formatting that depends on data from multiple - Microsoft Community

apologies in advance not knowing proper excel lingo:

i'm trying figure out if there's way highlight cells in 1 column if , if the date before today and status (in next column) value (enrolled or inactive opposed graduate or withdrawal). nb: spreadsheet formatted table.

i have no problem initial formatting dates (=date(year(b2)+5,month(b2),day(b2))), formatting supposed serve way remind me if additional fee due current students , becomes useless if tells me graduates , people have withdrawn owe fee.

here's mean:

an obvious solution create spreadsheet consists of enrolled or inactive students, nice if there way in single document.

any thoughts appreciated!

use formula conditional format:

=and(a1<today(),or(b1="enrolled",b1="inactive"))

Office / Excel / Other/unknown / Office 2016