Highlighting value 3x times greater than average

**Muz1993** · 12-15-2016, 04:29 AM

Hi all,

I am currently working on a set of data which required me to highlight data that 3x times greater than average by using vba. I try to code it myself but seem cannot find the solution.
Here my coding

Please Login or Register  to view this content.

**millz** · 12-15-2016, 04:47 AM

Try:

Please Login or Register  to view this content.

This exact formula worked when I manually create the format condition, not tested with VBA.

**Muz1993** · 12-15-2016, 08:56 PM

I seem cannot get the solution, it does not highlight the data that 3x times higher than average.

**millz** · 12-15-2016, 09:12 PM

Your code is looping all worksheets except "data" sheet though, is that what you want?

Please Login or Register  to view this content.

Post a sample workbook maybe.

Highlighting value 3x times greater than average

LinkBack

Thread Tools

Rate This Thread

Display

Highlighting value 3x times greater than average

Re: Highlighting value 3x times greater than average

Re: Highlighting value 3x times greater than average

Re: Highlighting value 3x times greater than average

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Highlighting numbers that appear more than 3 times

[SOLVED] Highlighting text in a column- a different colour for the amount of times it is repeated

Highlighting duplicates based on how many times they're duplicated

VBA for Highlighting values greater than and less than a number in selected range

How to Find which one is greater between 2 times

Macro Loop – Find Specific Times, Extract Date, Average Values of Times

Macro to help sort date - times and average similar times.

Bookmarks

Bookmarks

Posting Permissions