Home |
Search |
Today's Posts |
#1
|
|||
|
|||
CMD Button Help!!!!
My spreadsheet contains columns A - F. Column F contains dates. Column A
will be my flag column. When I press the command button if the date in column f is greater than 1 Jan 2005 I want a bold red "F" automatically placed in column a. Thanks in advance OS |
#2
|
|||
|
|||
Assuming that your data starts at Row2, put this formula into A2 ...
=If(F2Date(2005,1,1),"F","") Then copy the formula down as far as required. Then format ColA as Bold & Red. Rgds, ScottO "OriginalStealth" wrote in message ... | My spreadsheet contains columns A - F. Column F contains dates. Column A | will be my flag column. When I press the command button if the date in | column f is greater than 1 Jan 2005 I want a bold red "F" automatically | placed in column a. | | Thanks in advance | OS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
Command Button anomalies | Excel Discussion (Misc queries) | |||
Command Button VBA code | Excel Discussion (Misc queries) | |||
command button moves | Excel Discussion (Misc queries) | |||
How do I setup a spin button in excel | Excel Discussion (Misc queries) |