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

Hi Simon,

Select the rows you want conditional formatting to apply to, then in
conditional formatting enter this formula (suppose the condition is: cell
value in column A = "condvalue"):

=INDIRECT("A"&ROW())="condvalue"

and choose a format!

Replace ="condvalue" to your real condition, or post it to compose the
formula!

Regards,
Stefi


€˛simonvrowley€¯ ezt Ć*rta:

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.