Function for days between dates and an if statement (HELP)

G

getmhawks

I am trying to create a function where the time between two dates i
determined and if the amount of days is over 30 then their will be
red background placed in the cell. This maybe too complicated. I
that will not work then the cell beside the cell that has th
difference of the dates would have "overdue" written in red. Is thi
possible? I did figure out how to get the days between the two dates.
Any help would be greatly appreciated.

Andre
 
B

Bearacade

Why not just use conditional format for cell value over 30?

and then in the cell next to it. just put

=IF(A1>30, "OVERDUE", ""
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting two cell dates and highlight if over due by a certain amount of days 0
Conditional Formatting Conundrum 3
Help with an if then scenario 2
Conditional Formatting - Cannot get it to work, please help 1
IF Statement with Dates & Calculations 5
Function for returning quarter based on current date? 4
conditional formating with dates 1
Need to calculate the number of days between two dates on a 30 day 5

Top