how to highlight amount of a specific column of each tab

**karmanprof** · 02-14-2014, 02:51 PM

I like highlight for a partical column for each value which is greater than 500k and store it in a separate tab and another color for value greater than 100k, how difficult is it?

**JOHN H. DAVIS** · 02-14-2014, 03:19 PM

Maybe this can help to get you started?

Particular column used is A. Created one sheet Over 500K and another Over 100K

Please Login or Register  to view this content.

**HaHoBe** · 02-15-2014, 02:35 AM

Hi, karmanprof,

you could make good use of either applying the Autofilter or Advanced Fiter as well as Conditional Formatting if you want to get the result without programming.

Ciao,
Holger