| 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 | |||
Hybrid Mode
