CMD Button Help!!!!

O

OriginalStealth

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
 
S

ScottO

Assuming that your data starts at Row2, put this formula into A2 ...
=If(F2>Date(2005,1,1),"F","")
Then copy the formula down as far as required.
Then format ColA as Bold & Red.
Rgds,
ScottO

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
 
Top