Conditional Formatting - one cell value, format whole row

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.
inforrAsked:
Who is Participating?
 
TracyConnect With a Mentor VBA DeveloperCommented:
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
 
inforrAuthor Commented:
Bingo! Thank you - knew it was simple!!
0
 
barry houdiniConnect With a Mentor Commented:
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
 
TracyVBA DeveloperCommented:
No need to delete this question, just click Accept on the solution you want to accept.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.