Help with If/Or function

[Rscottq]

Hey all,

I'm keeping a log of vehicles we track. They are due for maintenance every 12 months or a specific mileage. I want a return to be in bold letters DUE. I already have the formula to calculate adding 12 months from last maint, and the specific mileage. I want the logical to calculate overdue. I had it right so far on the months, but tried to add the "OR" and cannot figure out what I'm doing wrong. Since I have cell for next mileage due, the monthly spreadsheet also has a report of that months mileage. This is why the "OR" function reads B13>C12. Figured that would be simplest. B13 is "Current Mileage", C12 is "Mileage Maint Req".

=IF(TODAY()>=EDATE($B11,12),"DUE","")=IF(OR($B13>$C12),"DUE","")

When I had just the date "DUE" populated where required. When I added the "OR" argument, I'm getting "FALSE" and "TRUE" which are not acceptable. Also help me make "DUE" bold?

Thanks in advance.

Scott

 

[Fluff]

Maybe

IF(OR(TODAY()>=EDATE($B11,12),$B13>$C12),"DUE","")

 

[Rscottq]

Maybe

IF(OR(TODAY()>=EDATE($B11,12),$B13>$C12),"DUE","")

PERFECT, just want to figure out how to make "DUE" bold.

 

[Fluff]

To make it bold you will need to format the cell as bold.

 

[jtakw]

just want to figure out how to make "DUE" bold.

Hi,

You can do this with CF (Conditional Formatting).
Assuming your formula is in Cell C13.
Select C13,
From Home tab, Select "Conditional Formatting"
"New Rule", "Use a formula......."
Enter the following formula in formula box:

=C13="DUE"

Select "Format", "Font" tab
Select "Bold" in Font Style box
Click OK.

Now the cell will ONLY be Bold if "Due" is the result, otherwise, it won't be Bold.

 

[Fluff]

As it's returning either Due or "" then using a simple cell format would (IMO) be far better than conditional formatting.

 

[Rscottq]

You guys were awesome!! Thanks much!!

 

[Fluff]

Glad to help & thanks for the feedback.