Conditional Formatting - one cell value, format whole row


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:


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

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:

Then click Format to format to the color you want and click ok.
inforrAuthor Commented:
Bingo! Thank you - knew it was simple!!
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


Otherwise every row will be formatted according to A1

regards, barry

TracyVBA DeveloperCommented:
No need to delete this question, just click Accept on the solution you want to accept.
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.