Need Two Formulas - Calculate Days Over Due and Turning Row Red

[kryshawk]

[TABLE="width: 500"]
<tbody>[TR]
[TD]MDT Date[/TD]
[TD]Next MDT[/TD]
[TD]Was MDT Met?[/TD]
[TD]Days Over Due[/TD]
[/TR]
[TR]
[TD]03/31/17[/TD]
[TD]06/30/17[/TD]
[TD]N[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]02/28/17[/TD]
[TD]05/10/17[/TD]
[TD]Y[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


First formula or conditional formatting is to create a formula that will turn the entire row red if the following conditions exist:

1. Column C is a "N"
2. Column B is past today's date.

2nd Formula - Calculate the number of days over due from Column B (using todays date) if Column C is a "N". IF column C is a "Y" leave blank.


My attempts have been to use Nested If, Conditional Formatting, and IFERROR statements.

HELP.

 

[FDibbins]

For the CF
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =and($C2="N",$B2>tody())
format fill RED

for the calc...
=if(C2="N",B2-today())
Might be better to put TODAY() in it's own cell, and reference that