Can I use conditional formatting to flag me when something is late?

[M. Swartztrauber]

Hello and thanks,

I have an excel (XP)workbook made up of 12 individually tabbed months
in which I put multiple billings. For each billing, the date the
individual bill was sent is input into a cell.

Is there a function that will compare today's date with the date
inputted and then (I guess using conditional formatting based on days
expired) turn the tab a different color to alert me that there is a
late payment within that month?

If not, any ideas that will approximate that approach would be truly
appreciated, too.

Thanks!

 

[Richard Choate]

You can't conditionally change the color of a tab without using code, but
you could use it to color some text bold red or something like that.
--
HTH
Richard Choate, CPA

Hello and thanks,

I have an excel (XP)workbook made up of 12 individually tabbed months
in which I put multiple billings. For each billing, the date the
individual bill was sent is input into a cell.

Is there a function that will compare today's date with the date
inputted and then (I guess using conditional formatting based on days
expired) turn the tab a different color to alert me that there is a
late payment within that month?

If not, any ideas that will approximate that approach would be truly
appreciated, too.

Thanks!

 

[M. Swartztrauber]

Dave,

Thanks for this help.

How might I alter this bit of code below if I wanted Excel to search
all of column A for the word "true" and change the tab color upon
finding an instance of it?

(I determined I actually had to have two criteria true in order to
need the function I talked about, hence the "AND(...)functions.)

Thanks!

 

[Dave Peterson]

=COUNTIF(A:A,TRUE)
In that helper cell might work for you.

(Is that what you meant?)