Change color of highest value

ctyong86 - Sep 1, 2010 at 04:16 AM
 ctyong86 - Sep 1, 2010 at 11:22 PM
Hello everyone, i need a favor.

i want to change the font color of the highest value from C3:X3

anyone can help me?

much appreciate.

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 1, 2010 at 05:43 AM
thre are many ways of doing it

select C3
click format-conditional formatting
in the conditional formatting window under "condition1" choose "the formula is"
in the next small window type
click "format" in the second row
choose Pattern and choose your color click ok
again click ok

select C3 click edit copy
select D3 t0 X3 and click edit-pastespecial-formats
click ok

the maximum of C3 to X3 will be colored.
Thank you so much, i have settle my problem ^^