Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
OriginalStealth
 
Posts: n/a
Default 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   Report Post  
ScottO
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel shoud not close all active books when clicking close button technomike Excel Discussion (Misc queries) 0 June 10th 05 05:35 PM
Command Button anomalies RWN Excel Discussion (Misc queries) 5 May 4th 05 05:09 AM
Command Button VBA code Dave Peterson Excel Discussion (Misc queries) 2 January 25th 05 11:28 PM
command button moves Stuart Excel Discussion (Misc queries) 2 December 15th 04 05:56 PM
How do I setup a spin button in excel Andy K Excel Discussion (Misc queries) 1 November 26th 04 09:08 PM


All times are GMT +1. The time now is 08:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"