View Single Post
  #1   Report Post  
Remote Desktop Connection hotkey
 
Posts: n/a
Default conditional formating which reacts on nerby cells

Is it possible to change formating of values in column A depending on value
in column B ?

For example i want to highlight value entered in cell A1 in red if Cell B1
value is 1 and highlight in blue if B1 is 2