| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Criteria - Automatic Change Font or Fill Colour
Hi all (posted in another forum incorrectly, sorry!) . 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=472517 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Font Colour Automatic When Formula Match | Excel Discussion (Misc queries) | |||
| Default cell comment fill color and font size | Excel Discussion (Misc queries) | |||
| Fill colour a cell from the linked cell | Excel Discussion (Misc queries) | |||
| Auto fill color change | Excel Discussion (Misc queries) | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Threaded Mode
