 |
 | 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 / New Users / September 2006Conditional formatting question?
I tried to set two conditional formats across the same range of cells using Format >> Conditional Formatting. I tried to set Formula Is =MAX(U5:AB5), font = red, and Formula Is =MIN(U5:AB5), font = green. The font in all cells turned red! What would be the correct way to do this? Ed Try: Formula Is =U5=MAX(U5:AB5) and copy the formatting across The problem is that by using Formula is, you need to give it a cell/value to compare to the maximum or minimum to give you the TRUE condition You could probably get away with Cell Value Is: Equal To: =MAX($U$5:$AB$5) and make sure you don't get any quotes round the formula Regards Trevor >I tried to set two conditional formats across the same range of cells using >Format >> Conditional Formatting. I tried to set Formula Is =MAX(U5:AB5), >font = red, and Formula Is =MIN(U5:AB5), font = green. The font in all >cells turned red! What would be the correct way to do this? > > Ed Thank you, Trevor. The > Cell Value Is: Equal To: =MAX($U$5:$AB$5) worked for me. Ed > Try: > [quoted text clipped - 16 lines] >> >> Ed You're welcome ... Thanks for the feedback > Thank you, Trevor. The >> Cell Value Is: Equal To: =MAX($U$5:$AB$5) [quoted text clipped - 22 lines] >>> >>> Ed |
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
|
©2008 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.