Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |