Add another For / Next to Macro

[Floydlevedale]

Hi All

I have the following macro that applies conditional formatting to every F15:F21 range in every wrksheet, when the condition is Greater than 50% then the color should be Red. How can I add another condition for a different range like X2:X10
font white when value is less than 3.

Please Login or Register  to view this content.

Many Thanks

[:) Sixthsense :)]

Try this...

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

[Floydlevedale]

Thanks Sixthsense, works like a bomb!