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
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?
"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.
Summary: I made an Excel Spreadsheet that is a list of products, the number of each product, and the value of each. What I want to do is use conditional formatting to highlight the products with the highest v...
Summary: Hi, I need to calculate how many times 2 specific characters appear in the same cell throughout an entire spreadsheet of about 98 columns and 98 rows, but I can't seem to find the right formula to do ...
Summary: Hi, In a time sheet I have created, there is start/end work time which works O.K. My problem is, that between 0:00 and 6:00 (night shift) there is different pay rate, so I have to calculate those...