 |
 | 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 / April 2008Conditional Formatting for Dummies
Another stupid inquiry from me, this time regarding conditional formatting. I have a cell that I would like to become shaded if any of four other cells are not blank; however, I would like it to deshade if all four cells are not blank. So I created conditional formatting with two formulas: #1: =OR(A1<>"",B1<>"",C1<>"",D1<>"") [SHADE CELL] #2: =AND(A1<>"",B1<>"",C1<>"",D1<>"") [DESHADE CELL] Clearly this isn't working, but I can't seem to figure out how to write it so it works. It's shaded if there is any value in any cell, and still shaded if all the cells have values. I'm sure the answer is simple but it's just not coming to me. Thanks for the help! If you're using Excel 2007, put the AND formula first and check Stop if True Tyro > Another stupid inquiry from me, this time regarding conditional > formatting. [quoted text clipped - 11 lines] > and still shaded if all the cells have values. I'm sure the answer is > simple but it's just not coming to me. Thanks for the help! Sadly, I am using 2003 :-/ > If you're using Excel 2007, put the AND formula first and check Stop if True > [quoted text clipped - 17 lines] > > - Show quoted text - My book on Excel 2007 tells me that in previous versions of Excel, if more than one conditional formula evaluated as true only the first conditional format was applied. That strongly suggests that if you put the AND formula before the OR formula that your formatting will work. Have you tried that? Tyro Sadly, I am using 2003 :-/ On Apr 15, 4:52 pm, "Tyro" <T...@hotmail.com> wrote: > If you're using Excel 2007, put the AND formula first and check Stop if > True [quoted text clipped - 23 lines] > > - Show quoted text - Try this as a *single* condition: =AND(COUNTIF(A1:D1,"<>")>=1,COUNTIF(A1:D1,"<>")<4)  SignatureHTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- Sadly, I am using 2003 :-/ On Apr 15, 4:52 pm, "Tyro" <T...@hotmail.com> wrote: > If you're using Excel 2007, put the AND formula first and check Stop if > True [quoted text clipped - 23 lines] > > - Show quoted text - |
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.