ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula Help !!!!!!!!! (https://www.excelbanter.com/excel-discussion-misc-queries/120620-re-formula-help.html)

Dave F

Formula Help !!!!!!!!!
 
You need to use conditional formatting.

Go to Data--Conditional Formatting, then go throught he dialog box you're
presented with.

Basically: select the range in question, select as your condition "Formula
is" and in the text box right the formula =MAX([your range]) and select the
color you want for highlighting. The max value in that range will be
highlighted.

Dave
--
Brevity is the soul of wit.


"Bishop8910" wrote:

I need a formula to highlight a cell if a cells is the highest in a range of
values.



All times are GMT +1. The time now is 12:05 AM.

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