Change color of highest value
Solved/Closed
Related:
- Change color of highest value
- Notepad++ change background color - Guide
- Change computer name cmd - Guide
- Change name of lg tv - Guide
- Color coding of rj45 - Guide
- How to change number of best friends on snapchat - Guide
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
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
=C3=MAX($C$3:$X$3)
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.
select C3
click format-conditional formatting
in the conditional formatting window under "condition1" choose "the formula is"
in the next small window type
=C3=MAX($C$3:$X$3)
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.
Sep 1, 2010 at 11:22 PM