Avatar of rtod2
rtod2
Flag for United States of America asked on

Excel 2010 - use of conditional highlighting

I have an excel tutorial that I am trying to follow through a series of tasks.  One of the tasks is on the use of conditional highlighting and says to "apply a yellow fill with dark yellow text to all outstanding checks where yes appears in the outstanding column".   I assume they mean to highlight the whole row that way.  Here is a screenshot http://screencast.com/t/Tk9sKOvrYkPh

Assistance is greatly appreciated.
Microsoft ExcelMicrosoft ApplicationsSpreadsheets

Avatar of undefined
Last Comment
Gerwin Jansen

8/22/2022 - Mon
Flyster

Not sure if they want the whole row or just the amount, but to achive it you would select conditional formatting, new rule, use formula to determinewhich cells to format. Assuming the screenshot you provided was a spreadsheet, the formula for row 2 would be =F3="Yes".

Flyster
ASKER CERTIFIED SOLUTION
Patrick Matthews

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Francis Omoruto

To add to what Flyster said, edit the rule to make sure it applies to the whole range. You may have to tweak the formula after that. Excel is rather nasty when you change the range of a conditional formatting rule!
SOLUTION
Gerwin Jansen

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck