Computing.Net > Forums > Office Software > Quattro spreadsheet formula

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Quattro spreadsheet formula

Reply to Message Icon

Name: Dakota1606
Date: March 27, 2009 at 07:08:50 Pacific
OS: Windows XP
Subcategory: General
Comment:

I have a formula on a Quattro spreadsheet that checks a condition and then responds with "Yes" (True) or "No" (False). I would like the "No" response to show up in the color red. Anybody know how to do that?



Sponsored Link
Ads by Google

Response Number 1
Name: DerbyDad03
Date: March 27, 2009 at 07:44:47 Pacific
Reply:

Does Quatro have Conditional Formatting like Excel?

That's what would be used if this was an Excel question.

Look up Formatting or Conditional Formatting in the Help files.


0

Response Number 2
Name: Dakota1606
Date: March 27, 2009 at 09:13:50 Pacific
Reply:

I was kind of past that. I could find nothing in Quattro about conditional formating, etc. I use it often in Excel, but can't find it in Quattro.

Thanks for your response.


0

Response Number 3
Name: DerbyDad03
Date: March 27, 2009 at 09:20:02 Pacific
Reply:

I found this which hints at the fact that Quatrro has Conditional Formatting. Maybe you've looked into this aleady:

Found at: http://www.pcpro.co.uk/reviews/5756...

"It's only when you get to conditional formatting that Excel excels when it comes to layout. Quattro's equivalent is called numeric formatting, and invoking it calls up a bewildering dialog box full of empty fields and drop-down menus. It's comprehensive, if nothing else, but daunting when you first see it."


0

Response Number 4
Name: Dakota1606
Date: March 27, 2009 at 13:31:55 Pacific
Reply:

Yes, thank you, I had found that already. I've been playing with it for hours and just can't get it to do what I want. In Excel it would have taken about 30 seconds. I'll keep plugging away.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Quattro spreadsheet formula

Excel Spreadsheet Formula www.computing.net/answers/office/excel-spreadsheet-formula/9360.html

Spreadsheet Formula Help!!! www.computing.net/answers/office/spreadsheet-formula-help/9742.html

Excel spreadsheet formula problem www.computing.net/answers/office/excel-spreadsheet-formula-problem/9473.html