• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

Conditional Formatting if Text

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
Geekamo
Asked:
Geekamo
1 Solution
 
Michael FowlerSolutions ConsultantCommented:
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
 
barry houdiniCommented:
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
 
GeekamoAuthor Commented:
Perfect, thank you!

~ Geekamo
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now