Highlight rows if value is bigger than 428 in Column (J)

**Tmc2159** · 07-12-2013, 09:37 AM

Hi All

You guys are just unbelievable so I figured I would ask you for your help.

Thanks for looking

I want to write a macro which highlights rows that have a value bigger than 428 in column(J).

I want the row to be highlighted out to Column(F).

Is it at all possible to do such a thing ?

Thanks everyone !!

Love,

Jess

**Richard Buttrey** · 07-12-2013, 09:40 AM

Hi,

Why do you need a macro when there are ways to use standard Excel functionality to achieve this. In this case you could use Conditional Formatting or if you just want to know in an additional helper column use a formula like
=IF(J1>428,"***","")

**JOHN H. DAVIS** · 07-12-2013, 09:50 AM

Maybe:

Please Login or Register  to view this content.

**Tmc2159** · 07-12-2013, 09:50 AM

I can't do that because I need to apply the formula automatically to around 220000 lines and 3500 sheets at a time.

It is also going to be part of a much bigger macro

**AB33** · 07-12-2013, 09:57 AM

Another one

Please Login or Register  to view this content.

Highlight rows if value is bigger than 428 in Column (J)

LinkBack

Thread Tools

Rate This Thread

Display

Highlight rows if value is bigger than 428 in Column (J)

Re: Highlight rows if value is bigger than 428 in Column (J)

Re: Highlight rows if value is bigger than 428 in Column (J)

Re: Highlight rows if value is bigger than 428 in Column (J)

Re: Highlight rows if value is bigger than 428 in Column (J)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions