Excel Conditional formatting

[ziad alsayed]

dear all

i am trying to use icon set in conditional formatting to show the maximum value on numbers. but i want only check to appear , i dont want the "X" or any other icons to appear. so i need only the check to appear near to the maximum amount.

please advise.

 

[Steve=True]

You may have to create a dummy column to display. and apply the conditional formatting to the dummy column and hide the original column.

=IF(B2=MAX(B2:B11),B2,"")

steve=true
www.exceldashboardtemplates.com

 

[ziad alsayed]

dear steve

thanks for the assistance, actually i took your idea of using the Max and by avoiding using a Dummy column i did the below

- set a conditional formatting, by using "format all cells base on their Values , i used the Max formula
- now i set up another conditional formatting by using " format cells only that contains" and set it < MAX and check the box stop if true.

it works.

thanks.