View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier[_2_] Roger Govier[_2_] is offline
external usenet poster
 
Posts: 57
Default 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.