• 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.

Custom farmatting

A

Ana Dsouza

New Member
Hi Team,
Please help in solving the below query

i want to highlight >100% cells value in excel table, can you please suggest custom formatting or coding for the highlighting the cells value >100% & <100%

Its Urgent...please help
 
K

KenU

Active Member
Although it would be impossible to guess a correct solution without a workbook or at least some cell references, you can use conditional formatting to achieve the highlighting based on such criteria. Keep in mind that Excel considers 100% to be equal to 1.

Hope that helps.

Ken
 
V

vletm

Excel Ninja
Ana Dsouza
1st You want urgent to highlight >100% ...
and
2nd You want to urgent to highlight >100% & <100% ...
...
Could You highlight only 100% ( based Your 2nd want )?
or
What do You really would like to do?
 
A

Ana Dsouza

New Member
KenU said:
Although it would be impossible to guess a correct solution without a workbook or at least some cell references, you can use conditional formatting to achieve the highlighting based on such criteria. Keep in mind that Excel considers 100% to be equal to 1.

Hope that helps.

Ken
Click to expand...

Hi, PFA excel file
 

Attachments

You must log in or register to reply here.
Top