Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conditional formatting rows on column values...
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conditional formatting rows on column values...
Hi
Try =$C1=TRUE -- Regards Roger Govier "kang" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conditional formatting rows on column values...
won't work either.
Roger Govier wrote: Hi Try =$C1=TRUE |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conditional formatting rows on column values...
formula: =$c1="TRUE"
"kang" wrote: won't work either. Roger Govier wrote: Hi Try =$C1=TRUE |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conditional formatting rows on column values...
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. |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conditional formatting rows on column values...
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. |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
conditional formatting rows on column values...
Hi,
Got it. Use formula: =$c1=TRUE Without any "" "Amul" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting for rows? | New Users to Excel | |||
Conditional Formatting of rows | Excel Discussion (Misc queries) | |||
Conditional Formatting for rows... | Excel Discussion (Misc queries) | |||
How to get more than 3 rows in Conditional Formatting | Excel Discussion (Misc queries) | |||
Values w/conditional formatting | Excel Worksheet Functions |