Change Font Colour Automatic When Formula Match

S

stevembe

Hi all. I have used some date formula in my worksheet:

=TODAY()+56
=TODAY()+84
=TODAY()+98

What I want to do is colour the font with the date if it meets the
criteria above. E.g. if I were to type anywhere on the worksheet a
date 55 days from today it would automatically turn red. If I were to
type in a date 80 days from today it would turn Blue etc

Also, if this can be done for the fill of the cells even better. Many
thanks in advaance and enjoy the day.
 
M

Max

One play using CF for try out provided in your identical post in
..worksheet.functions
 

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

Criteria - Automatic Change Font or Fill Colour 4
Conditional formula 1
Change cell colour 2
Using colour conditional formatting to show whether due date has past 0
Using CF to change colour in cell based on date? 4
Formula for Dates and CF Colour then convert to Text 3
change font colour after a date has expired 1
formula in conditional formatting with dates 3

Top