Change Font Colour Automatic When Formula Match
 

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.


--
stevembe
------------------------------------------------------------------------
stevembe's Profile: http://www.excelforum.com/member.php...o&userid=27743
View this thread: http://www.excelforum.com/showthread...hreadid=472516

See Tools/Conditional formatting and its Help if necessary
Regards,
Stefi


"stevembe" wrote:


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.


--
stevembe
------------------------------------------------------------------------
stevembe's Profile: http://www.excelforum.com/member.php...o&userid=27743
View this thread: http://www.excelforum.com/showthread...hreadid=472516

Format|conditional formatting??

Stefi wrote:

See Tools/Conditional formatting and its Help if necessary
Regards,
Stefi

"stevembe" wrote:


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.


--
stevembe
------------------------------------------------------------------------
stevembe's Profile: http://www.excelforum.com/member.php...o&userid=27743
View this thread: http://www.excelforum.com/showthread...hreadid=472516



--

Dave Peterson

One play using CF for try out provided in your identical post in
..worksheet.functions
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--