| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW TO INSERT "CONDITION" IN DATES BY EXCEL
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HOW TO INSERT "CONDITION" IN DATES BY EXCEL
You want conditional formatting (FormatConditional Formatting...)
You can set up to three conditions, so you would use something like: =today()-a1<=30 set color to red etc. -- Regards, Fred "Excel" wrote in message ... 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 |
|
#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 |
| Reply |
| 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 | |||
Linear Mode
