conditional formatting rows on column values...

[kang]

if C column has TRUE, I want the line(A through C column) to be formatted.
I want to use conditional formatting.
formula:="$c=TRUE"
target=$A$1:$C$274
I use excel 2007.

what's wrong?

TIA.

 

[Roger Govier]

Hi

Try
=$C1=TRUE

 

[kang]

won't work either.

 

[Amul]

formula: =$c1="TRUE"

won't work either.

 

[Amul]

Try this

=$c1<>"TRUE"

 

[Amul]

Hi,

It seems "TRUE" is a keyword.

So, try some other word like "TRUE1" or some ...

 

[Amul]

Hi,

Got it.

Use formula: =$c1=TRUE

Without any ""