View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default Highlight a row automatically if a cell meets certain criteria

Apply conditional Formatting to all cells of the row, with a formula like
=C10="testvalue"

HTH
--
AP

"simonvrowley" a écrit dans le
message de ...
I would like to know how to automatically highlight a row if one of the

cells
in the row meets certain criteria. I have managed to highlight the cell

with
conditional formatting but would like to be able to highlight the entire

row.