 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / December 2005Conditional formatting
I'm trying to conditonal formatting cells to highlight yellow when the cell is the max number. My problem is when trying to formatt the cells for example: cell G307 thru G327 and then skip a few cells then cells G330 thru G360 it does not work I highlite just those cells and the formula i'm using is =G307=MAX($G$307:$G$360) is this the correct formula? it works great if I don't skip any cells Thanks The below works for me. Substitute the cell where you want the format to appear for A1 in the below formula. =A1=MAX(G307:G327,G330:G360) Hope this helps. Bill Horton > I'm trying to conditonal formatting cells to highlight yellow when the cell > is the max number. My problem is when trying to formatt the cells for example: [quoted text clipped - 6 lines] > it works great if I don't skip any cells > Thanks When I do that and I formatt with yellow, I put 64 in the first cell and half the yellow cells stay yellow and the other half stay white. Seems like everytime I do it it does something different. Kinda wierd > The below works for me. Substitute the cell where you want the format to > appear for A1 in the below formula. [quoted text clipped - 15 lines] > > it works great if I don't skip any cells > > Thanks Perhaps you should select G307:G327,G330:G360 and use a CF formula of =G307=MAX($G$307:$G$327,$G$330:$G$360)  SignatureHTH RP (remove nothere from the email address if mailing direct) > When I do that and I formatt with yellow, I put 64 in the first cell and half > the yellow cells stay yellow and the other half stay white. Seems like [quoted text clipped - 19 lines] > > > it works great if I don't skip any cells > > > Thanks I might have misunderstood, but it seems after using the cursor to highlight the cells you want, you could just use the Comditional Formatting under Format to set the parameters for those cells. "Cell value is greater than or equal to" would handle turning the cell a specified color if the number is higher than what you specify. > I'm trying to conditonal formatting cells to highlight yellow when the cell > is the max number. My problem is when trying to formatt the cells for example: [quoted text clipped - 6 lines] > it works great if I don't skip any cells > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.