conditional formatting row based on value

[lezawang]

Hi
I want to highlight all rows which has TRUE in column F. So I highlighted the who table except labels and then Conditional Formatting-->Rules and type this

=$F2="true"
Color Green

But did not work? any idea why? Thank you

[TABLE="class: grid, width: 591"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]city1[/TD]
[TD]city2[/TD]
[TD]price[/TD]
[TD]whole sale price[/TD]
[TD]crit[/TD]
[/TR]
[TR]
[TD="align: right"]7\02\2018[/TD]
[TD="align: right"]32.22[/TD]
[TD="align: right"]26.91[/TD]
[TD="align: right"]49.92[/TD]
[TD="align: right"]69.88[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: right"]7\03\2018[/TD]
[TD="align: right"]32.85[/TD]
[TD="align: right"]28.51[/TD]
[TD="align: right"]48.81[/TD]
[TD="align: right"]54.3[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: right"]7\05\2018[/TD]
[TD="align: right"]30.69[/TD]
[TD="align: right"]24.58[/TD]
[TD="align: right"]53.43[/TD]
[TD="align: right"]43.77[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: right"]7\06\2018[/TD]
[TD="align: right"]28.92[/TD]
[TD="align: right"]23.16[/TD]
[TD="align: right"]30.02[/TD]
[TD="align: right"]35.19[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="align: right"]7\09\2018[/TD]
[TD="align: right"]27.74[/TD]
[TD="align: right"]25.52[/TD]
[TD="align: right"]40.59[/TD]
[TD="align: right"]34.6[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="align: right"]7\10\2018[/TD]
[TD="align: right"]32.22[/TD]
[TD="align: right"]26.98[/TD]
[TD="align: right"]44.87[/TD]
[TD="align: right"]42.53[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="align: right"]7\11\2018[/TD]
[TD="align: right"]31.08[/TD]
[TD="align: right"]24.13[/TD]
[TD="align: right"]42.01[/TD]
[TD="align: right"]38.76[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
</tbody>[/TABLE]

 

[RoryA]

Just use:

=$F2

since your cells appear to already have TRUE/FALSE values in them, not text.