View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Conditional Formating an entire row

CF/ Formula Is/ =$A1=42

Note: Formula Is, not Cell Value Is, and note absolute addressing for
column reference.
--
David Biddulph

"cardosol" wrote in message
...
How do I apply conditional formatting to an entire row based on one cell?