<div>
Bingo! Thank you - knew it was simple!!
</div>


<div>
No need to delete this question, just click Accept on the solution you want to accept.
</div>


No need to delete this question, just click Accept on the solution you want to accept.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
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:<br />
<br />
=&quot;IF($A1=&quot;&quot;Yes&quot;&quot;,TRUE)<br />
<br />
But it doesn't work, what am I doing wrong?<br />
<br />
Thanks.
</div>
</div>


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.

Conditional Formatting - one cell value, format whole row

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.