Conditional Formating for "Stale" Cheques.

  • Thread starter Thread starter Matthew
  • Start date Start date
M

Matthew

Hello, I have a worksheet that contains a cheque register. Columns are:
Date, Cheque Number, Payee, Amount & Status. When the date in my first
column becomes older than 15 months (i think that is 420 days) i would like
the Date or Amount (or maybe both) to become Bold with Red text to indicate
that the cheque is stale. I have spent hours fooling around with this and
any help would be appreciated.

Thanks.
 
Matthew said:
Hello, I have a worksheet that contains a cheque register. Columns are:
Date, Cheque Number, Payee, Amount & Status. When the date in my first
column becomes older than 15 months (i think that is 420 days) i would like
the Date or Amount (or maybe both) to become Bold with Red text to indicate
that the cheque is stale. I have spent hours fooling around with this and
any help would be appreciated.

Thanks.
Click to expand...

I can help you out with the date cell. In the conditional formatting window
the boxes from left to right need to read:

1. Cell Value Is
2. less than
3. =TODAY()-420

Then just set the format to bold and red text using the format button at the
bottom of the window.

Hope this is helpful, any probs get back to me!
 
Back
Top