• 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

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
 
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
 
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?
 
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


Hi, PFA excel file
 

Attachments

  • Custom Formatting.xlsx
    9.8 KB · Views: 3
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?

Hi Veltm,

Wish you Happy New year!!!
Thanks for your reply,
Please refer the attached file for required output
 

Attachments

  • Custom Formatting.xlsx
    10 KB · Views: 5
Back
Top