LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Roy
 
Posts: n/a
Default Conditional Formating

I have set up in conditonal formating to change cell patterns to be a certain
color based on the date. The below conditional formating formula works, now
what I need to for the words (Red, Yellow, or Green to automatically appear
in the cell based on the color i.e if cell color is Red I what the word Red
to appear in the cell. How can I do this?

=F2<=TODAY() (pattern color Red)
=F2<=TODAY()+5 (pattern color Yellow)
=F2<=TODAY()+25 (pattern color Green)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formating Daniell Excel Discussion (Misc queries) 3 May 10th 05 05:48 PM
Expanding conditional formating with reference cells changing CCoop Excel Discussion (Misc queries) 2 May 4th 05 02:36 PM
more than 3 conditional formating in excel Manan Excel Discussion (Misc queries) 2 February 7th 05 09:12 PM
Conditional Formating when result is text Lary Excel Worksheet Functions 1 December 16th 04 02:13 AM
30 Day Aging Report Using Conditional Formating Tiegris Excel Worksheet Functions 0 November 4th 04 10:07 PM


All times are GMT +1. The time now is 06:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"