Solved

Conditional Formatting - one cell value, format whole row

Posted on 2011-02-24
4
545 Views
Last Modified: 2012-05-11
Hi,

I have a spreadsheet whereby I want the whole row to be one colour based on the value of a cell within that row. I have tried using a conditional formatting formula such as:

="IF($A1=""Yes"",TRUE)

But it doesn't work, what am I doing wrong?

Thanks.
0
Comment
Question by:inforr
  • 2
4 Comments
 
LVL 24

Accepted Solution

by:
broomee9 earned 125 total points
ID: 34970084
Try this:

Select the row, then click Format --> Conditional Formatting.  Select Formula Is and enter this:
=$A$1="Yes"

Then click Format to format to the color you want and click ok.
0
 

Author Comment

by:inforr
ID: 34970096
Bingo! Thank you - knew it was simple!!
0
 
LVL 50

Assisted Solution

by:barry houdini
barry houdini earned 125 total points
ID: 34970139
If you want to copy the conditional formating to other rows so that the formatting depends on the column A value in that particular row then you should only retain the first $, i.e. use

=$A1="Yes"

Otherwise every row will be formatted according to A1

regards, barry

0
 
LVL 24

Expert Comment

by:broomee9
ID: 34970313
No need to delete this question, just click Accept on the solution you want to accept.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now