| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO INSERT "CONDITION" IN DATES BY EXCEL
I would suggest using conditional formating and use a formula with three
conditions in this order if the date is in A1: =$A$1<TODAY()-45 set fill color blue =$A$1<TODAY()-30 set fill color yellow =$A$1<=TODAY() set fill color red -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Excel" wrote: I wanna insert a formula with dates in which I need 3 different colours. Eg. until 30 days ago, the sentence has to be red, 31 to 45 days ago, the sentence has to be yellow and before 45 days ago, e.i. 46 days ago or more, the sentence has to be blue. Thanks. Alves |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
| How do I use the "SUMIF" function using dates as a condition | Excel Worksheet Functions | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
| Adding "New" "Insert" "Delete" into a workbook to change from data 1 to data 2 etc | Excel Programming | |||
Threaded Mode
