| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use months in formula.
A column has different months entered. Generally these will be a month
either side of the current month, or the current month itself. I would like to use conditional formatting to change the cell colour to: Green - Next month Amber - Current month Red - Last month and beyond. How can I do this without specifying +/- number of days, as there are a different number of days in each month? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| formula to count number of months that have passed | Excel Discussion (Misc queries) | |||
| How can I find the greatest possible sum within 12 months? A newbie... | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula to calucate # of months based on a speificed date entered | Excel Worksheet Functions | |||
Threaded Mode
