Thread: Conditional format based on adjacent cell value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Snidow Greg Snidow is offline
external usenet poster
  
Posts: 153
Default Conditional format based on adjacent cell value
Greetings all. I am trying to use conditional formatting for a cell based on
the value of the adjacent cell. So, I want cell T1 to change to red if U1 =
"No". I tried Formula is =IF(U1 = "No"), but I get a formula error. Could
this be done with a Macro instead? Thank you.

Greg
Reply With QuoteReply With Quote