17 days ago by Michelle Mangen

Conditional Formatting is probably one of my favorite things in Excel – the possibilities are probably nearly endless. This post and video will explain two uses for Conditional Formatting: How to have cells recolored automatically based on the text in the cell Automatically alternate row colors usin ...

The Virtual Assistant - thevirtualasst.com · 8 references

19 days ago by Jon Peltier

A reader encountered problems applying conditional formatting to a pivot table. I tried it myself, using the same kind of formulas I would have applied in a regular worksheet range, and had no problem. The reader responded that he was having problems in Excel 2007, and I was using 2003. Apparently i ...

PTS Blog - peltiertech.com/WordPress · Rank: 7,674 · 74 references

21 days ago by Jim Mathew

Below are the values for conditional formatting example usage :

Jim Mathew's Sharepoint ... - sharepointjim.wordpress.com

21 days ago by Frederik Van Lierde

Using Repeating Tables, sections etc in an InforPath form gave great opportunities, but sometimes we want to limit the numbers of rows that can be inserted. Ex. Max 10 files can be added to the InfoPath Form Ex. Max 3 people can subscribe for a carpooling list for 1 car Solution: 1. Select the repea ...

InfoPath Blog - blueinfopath.wordpress.com

26 days ago by Debra Dalgleish

Garbage in, garbage out. You depend on Excel spreadsheets to show accurate data and analysis. Enter the wrong data and the results will be incorrect, and that could have a negative impact on your business or reputation. Here are 3 ways to help safeguard your data entry. I’m sure you use a few other ...

Contextures Blog - blog.contextures.com · Rank: 120,917 · 18 references

27 days ago by Ask This CFO

A quick and easy method to SUM/ ADD / TOTAL a range of cells in Excel is simply to select cells by using the SHIFT+ARROW KEY and the SUM will be displayed at the bottom. Posted in CFO Insight, Excel - Helpful Hints & Tips

Ask This CFO - askthiscfo.wordpress.com

33 days ago by Ask This CFO

F1 Displays the Help Window CTRL+F1 Closes and reopens Help Window. ALT+F1 Creates a chart based on selected range of cells in the current worksheet. ALT+SHIFT+F1 inserts a new worksheet. F2 This is command used by Lotus 1-2-3 users, allows you to Edit active cell. SHIFT+F2 allows you to edit the co ...

Ask This CFO - askthiscfo.wordpress.com

40 days ago by Debra Dalgleish

A few weeks ago we looked at a way to fill blank cells in an Excel report, so you’d be able to filter or sort a table of data. The downside of that technique is that it’s harder to pick out the sections in a report. The headings don’t pop off the page, but are buried in a long list of items. You can ...

Contextures Blog - blog.contextures.com · Rank: 120,917 · 18 references

51 days ago by mattm

One of the great additions this year to the Qualtrics Research Suite is the “Test Survey” option in the Advanced Options menu. This allows you to ask the system to take the survey for you multiple times. This will help sort out any issues you might have with your survey before it is activated. You c ...

Qualtrics Blog - qualtrics.com/blog · 2 references

52 days ago by Prasanth Chandra

If you need to differentiate between data without sorting it, you can do it with ease in Excel 2007. Using the " Conditional Formatting" rules in Excel 2007, you can easily segregate even numbers from the odd numbers in your data. This is called Value based Shading which means adding color to specifi ...

PC's Place - pcsplace.com · Rank: 23,528 · 51 references