![]() |
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