Best Way to Conditionally Format Range (Multiple Columns and Rows)?

Hi Everyone,

I'm looking to put some conditional formatting in to a macro of mine. I have a chart of data and I'd like the formatting to highlight any cell that doesn't equal column B in that row. For example:

If C6 is greater than .5 and it doesn't equal B6, then it gets highlighted. If H22 is greater than .5 and doesn't equal B22, then it gets highlighted.

I'm not sure how much this will change things but the amount of rows and columns are both dynamic. I already have them defined using LastRowC and LastColC. The range that the conditional formatting should go through is B3 through LastRowC and LastColC.

Let me know if you need more info.

Thanks!

Hi again Solus -

Do you mean just using the macro recorder and doing the conditional formatting that way? I tried it and I can't seem to find a way to make it so that each column is compared to column C. They seem to shift. If you mean, why don't I just use conditional formatting instead of a macro, that won't work because the ranges are dynamic so the conditional formatting would have to be reprogrammed every time the user runs the macro.

Let me know if you need any other info.

Thanks!

Maybe:

Please Login or Register  to view this content.

John - That doesn't seem to be making any changes...

Solus - I understand how conditional formatting works and where to find it. That doesn't solve my question as how to code conditional formatting within vba.

Originally Posted by freybe06

John - That doesn't seem to be making any changes...

Solus - I understand how conditional formatting works and where to find it. That doesn't solve my question as how to code conditional formatting within vba.

Can you post a sample to test on? When I ran it some made up data it seemed to work.

Attached is a test book with the macro inserted.

Attachment 277924


Also, I know this is kinda frowned upon, but I was hoping you'd be able to take a quick look at this and tell me why its not working...I'm trying to make it so that any time the word "hello" shows up in column C of each worksheet, that row is deleted.

Please Login or Register  to view this content.

Thanks!