Solved

Conditional Formatting if Text

Posted on 2013-01-17
3
334 Views
Last Modified: 2013-01-19
Hello Experts,

I am using this formula,...

=IF(COUNT(C17:E17)=3,"Bag Size: "&C17+1&"""W x "&D17+1&"""D x "&E17+D17+6&"""L","")

It's result, I think would be considered text - even though there are # values within the text.

Anyhow,... my goal is to apply conditional formatting to that cell - if a value is returned.

Thank you in advance for your help!

~ Geekamo
0
Comment
Question by:Geekamo
3 Comments
 
LVL 23

Expert Comment

by:Michael74
ID: 38791875
The conditional formating looks at the value in the cell not the formula and so just use conditional formatting as per normal

http://office.microsoft.com/en-au/excel-help/quick-start-apply-conditional-formatting-HA010370614.aspx

Michael
0
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 38792543
If you want to distinguish between an actual value returned, e.g. like "Bag Size: 2"W x 3"D x 11"L" or "" (a blank) returned then you can't use ISTEXT function because "" (a blank) is regarded as text, too

Assuming formula in F17 you can use this formula in conditional formatting

=F17<>""

or you could also just use the condition from your formula, i.e.

=COUNT(C17:E17)=3

regards, barry
0
 
LVL 1

Author Closing Comment

by:Geekamo
ID: 38797806
Perfect, thank you!

~ Geekamo
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now