View Single Post
  #1   Report Post  
68magnolia71
 
Posts: n/a
Default Condtional formatting

Hello everyone,

I'm looking for a condtional formatting formula based on 2 conditions. The
conditions are based on a text that are in 2 different cells in the same row.
For example: if A1 contains "Start" and A2 contains "Operation" I want row 1
green; if if A1 contains "Stop" and A2 contains "Operation" I want row 1 red.
A1 and A2 contain drop down list. All other combinations should give the
rows blue.
This last condition is a normal cell format. At least 15 columns in the
speadsheet.

Has someone an idea solve the problem?
Thank you for any suggestion