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.
|