Thread: highlighting the whole row when criteria is met in one cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default 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
Reply With QuoteReply With Quote