 |
 | 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 / February 2008Conditional formatting
Condition:- If cell C48 is not blank AND cell C49 is blank then colour cell C49 light yellow. I have placed the following in condition 1 for Cell C49 =AND(NOT(ISBLANK(C48)),ISBLANK(C49)) however the cell colour changes to light yellow when C48 is blank and C49 is blank. Where am I going wrong? Sandy Are you sure that C48 is really blank? Enter this formula somewhere: =LEN(C48) and it should return 0 if the cell is empty (you might have one or more spaces in there which look blank). Another way of trying this is: =AND(C48<>"",C49="") Hope this helps. Pete > Condition:- If cell C48 is not blank AND cell C49 is blank then colour cell > C49 light yellow. [quoted text clipped - 8 lines] > > Sandy Hi Pete =LEN(C48) placed elsewhere shows 0 However using your formula =AND(C48<>"",C49="") produces the desired results! On thinking about this again there is a formula in C48 so I presume that had a bearing on things?? Thanks Pete Sandy > Are you sure that C48 is really blank? Enter this formula somewhere: > [quoted text clipped - 25 lines] >> >> Sandy Glad to hear that, Sandy - thanks for feeding back. Personally, I avoid using ISBLANK, as its results can be a bit confusing. Pete > Hi Pete > [quoted text clipped - 40 lines] > > - Show quoted text - > On thinking about this again there is a formula in C48 so I presume that > had a bearing on things?? By definition if C48 has a formula in it then it can't be blank so ISBLANK() will alwayts return FALSE  SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Hi Pete > [quoted text clipped - 38 lines] >>> >>> Sandy |
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.