3 colour in conditional format

  • Thread starter Thread starter augurmaster
  • Start date Start date
A

augurmaster

i was made my mp3 list in excel.....currently i have successfully used
conditional format based on coloumn criteria (i`m using a combo box
just 'yes' and 'no')....my first conditional format is like this
(=$H5:H407= "NO") and second one (=$IT5:IT407= "NO")....
but i don`t know how to make a third one...i mean to combine th
formula.....when these two coloumns is "NO".......anyone can help....
 
Condition 1 should check both columns: =AND($H5="No","$I5="No")
Condition 2 can check column H for "No"
Condition 3 can check column I for "No"
 
Back
Top