• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional Formatting

Viral Vaishnav

New Member
I have percentage data of achievement.

There are three types:

High - to be colored Green - More than 20%
Moderat - to be colored yellow - Between 15 and 20%
Low - to be colored Red - Less than 15%

I want to apply conditional formatting for above conditions. But not able to do the same for "MODERATE".

Waiting for help..
 
@Hellow Vishal,

Welcome to the forum.

Please upload a sample file of data so that we can assist you.

VDS
 
Hi Viral,

Supposing Column A from A1 has the %age data, try below formula by selecting the range:

=AND(A1>=0.15,A1<=0.2)

Regards,
 
Back
Top