Font colour

  • Thread starter Thread starter Boenerge
  • Start date Start date
B

Boenerge

How do I get the fonts in a spreadsheet to change colour two months before
the date inserted.
Thanks in adavnce
Jason
 
Hi Bob,
What I don't understand is how to set the formatting so that it is two
months before the date in the cell.
Thanks
Jason
 
Depending upon the cells, it would be a formula of something like

=B1<=DATE(YEAR(A1),MONTH(A1)-2,DAY(A1))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

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

Advanced conditional formatting 1
hyperlink formatting 2
Palette problem 4
Copy and Paste (Excel to PowerPoint) 1
Header & Footer - Font colour 3
Can't change the cell back to blank when there is a date in it. 0
Macro code to partially format font colour of result in cellcontaining a formula 3
Changing Font Colour of row depending on selection made in 1st col 1

Back
Top