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

Date	city1	city2	price	whole sale price	crit
7\02\2018	32.22	26.91	49.92	69.88	TRUE
7\03\2018	32.85	28.51	48.81	54.3	TRUE
7\05\2018	30.69	24.58	53.43	43.77	TRUE
7\06\2018	28.92	23.16	30.02	35.19	FALSE
7\09\2018	27.74	25.52	40.59	34.6	FALSE
7\10\2018	32.22	26.98	44.87	42.53	TRUE
7\11\2018	31.08	24.13	42.01	38.76	TRUE

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[RoryA]

Just use:

=$F2

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