conditional formatting rows on column values...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kang - 23 Jul 2007 11:37 GMT

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.

Reply to this Message

Roger Govier - 23 Jul 2007 11:40 GMT

Hi

Try
=$C1=TRUE

Signature

Regards
Roger Govier

> if C column has TRUE, I want the line(A through C column) to be formatted.
> I want to use conditional formatting.
[quoted text clipped - 5 lines]
>
> TIA.

Reply to this Message

kang - 24 Jul 2007 09:46 GMT

won't work either.

> Hi
>
> Try
> =$C1=TRUE

Reply to this Message

Amul - 25 Jul 2007 07:34 GMT

formula: =$c1="TRUE"

> won't work either.
>
> > Hi
> >
> > Try
> > =$C1=TRUE

Reply to this Message

Amul - 25 Jul 2007 07:38 GMT

Try this

=$c1<>"TRUE"

> if C column has TRUE, I want the line(A through C column) to be formatted.
> I want to use conditional formatting.
[quoted text clipped - 5 lines]
>
> TIA.

Reply to this Message

Amul - 25 Jul 2007 07:46 GMT

Hi,

It seems "TRUE" is a keyword.

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

> Try this
>
[quoted text clipped - 9 lines]
> >
> > TIA.

Reply to this Message

Amul - 25 Jul 2007 07:58 GMT

Hi,

Got it.

Use formula: =$c1=TRUE

Without any ""

> Hi,
>
[quoted text clipped - 15 lines]
> > >
> > > TIA.

Reply to this Message

Rate this thread: