Highlighting a Cell, based on value / blank.

**robert_shindorf** · 12-29-2008, 06:42 PM

Hi folks..

I have a macro, and it mainly works, except the second part where it checks if the value is less than 7, and returns it to a white background.

The cell has a formula in it that returns "" based on another series of cells. I have considered changing that to a zero and formating, but for reasons that don't need explanation, i have chosen not to.

here is the macro. I need the second part to be activated if less than 7, as well as if the cell returns ""

Please Login or Register  to view this content.

Thanks in advance.

**Richard Buttrey** · 12-29-2008, 06:55 PM

Hi,

Perhaps

Please Login or Register  to view this content.

HTH

**robert_shindorf** · 12-29-2008, 06:59 PM

ahhh ha!

I was trying to write it like a formula or(condition1, consition2)

haha, thanks!

**robert_shindorf** · 12-29-2008, 07:09 PM

woops, looks like one more thing is happening, when the workbook changes, it moves the selected cell to column 10, is there something i can add to the end to keep the selection where it is?

**Richard Buttrey** · 12-29-2008, 07:29 PM

Originally Posted by robert_shindorf

woops, looks like one more thing is happening, when the workbook changes, it moves the selected cell to column 10, is there something i can add to the end to keep the selection where it is?

Hi,

Assuming you're talking about column F being the active colum,

Please Login or Register  to view this content.

But I can't help thinking you're better not selecting column 10 in the first place. Try and avoid .Select and .Activate.

Try just

Please Login or Register  to view this content.

HTH

**robert_shindorf** · 12-29-2008, 07:42 PM

you were absolutely right... avoiding selecting that cell was better a better bet.

thanks again.

Highlighting a Cell, based on value / blank.

LinkBack

Thread Tools

Rate This Thread

Display

Highlighting a Cell, based on value / blank.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions