PC Review


Reply
Thread Tools Rate Thread

Another If/Ten

 
 
Brian Bennett
Guest
Posts: n/a
 
      16th May 2007
HI all.

Trying to use IF/THEN to look at Column A on one sheet, if any cell in that
column equals today() would like cells from that row to fill in another
sheet.

Is this possible? Any ideas on how to make that happen??

Thanks.

Flue.
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      16th May 2007
Maybe you can use format|Conditional formatting.

Select the range to color (I used A2:X999).

With A2 the activecell, I did:
format|conditional formatting
formula is:
=($a2=today())
and give it a nice format



Brian Bennett wrote:
>
> HI all.
>
> Trying to use IF/THEN to look at Column A on one sheet, if any cell in that
> column equals today() would like cells from that row to fill in another
> sheet.
>
> Is this possible? Any ideas on how to make that happen??
>
> Thanks.
>
> Flue.


--

Dave Peterson
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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



Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:19 AM.