ExcelBanter - highlighting the whole row when criteria is met in one cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - highlighting the whole row when criteria is met in one cell (https://www.excelbanter.com/excel-discussion-misc-queries/242695-highlighting-whole-row-when-criteria-met-one-cell.html)

Honkus

highlighting the whole row when criteria is met in one cell

--
Honkus

Jacob Skaria

highlighting the whole row when criteria is met in one cell

Select the rows to be highlighted

Use the formula. Note that the column is absolute referenced...
=$E1="Yes"

If this post helps click Yes
---------------
Jacob Skaria

"Honkus" wrote:

--
Honkus

All times are GMT +1. The time now is 06:52 AM.