| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel flags cells
Hi,
I have a spreadsheet that was created by another individual where we have two columns of dates. The purpose of the dates is to make sure one year does not elapse between a task which is performed. Currently the cells will turn red if a year has elapsed between the two dates - there is no macro currently written for this. I have not been able to figure out how this was done. I am able to duplicate the information by copying and pasting but do not know how it is done fundamentally. Any thoughts are appreciated. Thanks, Chad |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel flags cells
Format/ Conditional Formatting
-- David Biddulph "Chadersmith" wrote in message ... Hi, I have a spreadsheet that was created by another individual where we have two columns of dates. The purpose of the dates is to make sure one year does not elapse between a task which is performed. Currently the cells will turn red if a year has elapsed between the two dates - there is no macro currently written for this. I have not been able to figure out how this was done. I am able to duplicate the information by copying and pasting but do not know how it is done fundamentally. Any thoughts are appreciated. Thanks, Chad |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| Can I connect Excel cells to cells in an embedded Word table? | Excel Discussion (Misc queries) | |||
| How to get =MIN() given flags? | Excel Worksheet Functions | |||
| Can a "flags" or "reminders" be used in a ws | New Users to Excel | |||
| Pasting single cells from Word to multiple cells in Excel | Excel Worksheet Functions | |||
Linear Mode
