Take the first step in growing your Excel skills

re: Take the first step in growing your Excel skills

nelsontcpa — Thu, 14 Jul 2011 19:45:16 GMT

Need help with Excel 2010 conditional formatting:

I need to have a conditional format for a cell where the color of the cell changes based upon 3 conditions. If the value of the cell is between 0-69 (<70) the cell is green, between 70-121 the cell is yellow and if the value is >121 the cell is red.

Where in excel 2010 can I create 3 conditions for the same cell?

re: Take the first step in growing your Excel skills

vipul_theunexpected — Wed, 08 Jun 2011 22:49:40 GMT

dont know where to post a question regarding excel...... so here i go

lets say...

a table having 3 columns row1(id, age, secondary id)......row2(123, 24, 9999)

if i have to lookup for value 123 in column1 and return value from column3 then the formula will be....=vlookup(123,a2:c2,3,false)..... it will return 9999.

My question is.... what is the formula

If i have to lookup for value 9999 in column3 "secondary id" and return value 123 from column1 "id"

help will be really appreciated

Thanks

re: Take the first step in growing your Excel skills

Amy Miller — Thu, 19 May 2011 22:11:27 GMT

@macd144 - great question. The idea behind the Excel Skills Builder is to provide more introductory-type content to features and tasks in Excel. Your questions are pretty specific. I would check out Microsoft Answers: answers.microsoft.com/.../office. You could also try posting these types of questions to the Excel Facebook page at www.facebook.com/.../set

@lstewart: So glad you liked the first lesson. The next 3 will be avaliable soon, and I'll be sure to announce them on the blog when they go live. There may be more of this type of training for other Office apps in the near future...especially if users find the Excel videos useful.

re: Take the first step in growing your Excel skills

lstewart@stewarttraining.com — Wed, 18 May 2011 20:17:18 GMT

I think these are great and was ready to share until I saw how few there were. I'm anxiously awaiting the next series. Are you doing any for Word?

re: Take the first step in growing your Excel skills

macd144 — Fri, 13 May 2011 15:45:52 GMT

Amy

Sounds great, but something that is in the format of a video series, especially when they tend to be short, is unlikely to cover some of the details I would need. For example, very specific info about when I freeze panes at column D, Excel freezes it at column H everytime I have some columns further to the right i the spreadsheet 'grouped'. Where does someone get training or help to such a specific question?