Re: Format cell if contains a value

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 06/02/04 

Date: Wed, 2 Jun 2004 09:02:33 -0400

You can replace
Active***.Cells.

with any valid multiple cell reference and it will work only within that
reference.

BillyB's suggestion is really just an extension of the specialcells method I
suggested. So you should get similar results if you use Active***.Cells
except that he only uses the constants part of my suggestion. 

-- 
Regards,
Tom Ogilvy
"sjbeeny >" <<sjbeeny.177lz7@excelforum-nospam.com> wrote in message
news:sjbeeny.177lz7@excelforum-nospam.com...
> Wow, Thanks for all the responses guys
>
> Tom, I was wondering if I could limit your formulae to a specific range
> in some manner. I should have been more clear when I first asked the
> question but I only want to reformat the new cells entered in ranges
> "TitleInvoice","PriceInvoice" and "TotalInvoice" I used your formulae
> and it worked a little too well and changed the format of all cells
> (Headings etc.)
>
> Chip, I tried using your procedure except I changed the range to the
> above ("TitleInvoice","PriceInvoice" and "TotalInvoice") but for some
> reason I got an error debug msg I will look further into it.
>
> Billyb thanks for the suggestions I am yet to have a play around with
> them but will do tonight.
>
> Thanks for all the imput everyone!
>
> Regards,
> Simon
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>
Quantcast