View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe M. Joe M. is offline
external usenet poster
 
Posts: 97
Default Extend conditional format to other rows

I want to change the color of a row's text based upon the value "No" in the
same row. I want to extend this for the other rows on the same sheet. For
example:
If cell D2="No" then text in row 2 is red.
If cell D3="No" then text in row 3 is red.
etc...
The sheet is already filled so I need to apply this formatting afterward.
Can someone help please?