Hi,

It seems "TRUE" is a keyword.

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



"Amul" wrote:

Try this

=$c1<"TRUE"

"kang" wrote:

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.