ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Conditional formatting of a column of values (https://www.excelbanter.com/excel-programming/310201-re-conditional-formatting-column-values.html)

JE McGimpsey

Conditional formatting of a column of values
 
One way:

Select the column, say, column A, with the cell in row 1 (e.g., A1)
active. Choose Format/Conditional Formatting...

CF1: Formula is =A1=MAX(A:A)


In article ,
Joe wrote:

I'm looking to c.f. a column of values that show the highest value based on
the other values in that column.



All times are GMT +1. The time now is 11:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com