- Nov 16, 2005
I want say.... in cell q2 for it to first look at d2 to see if I have a "C" or "S" in that cell, if d2 has "C" and the formula in q2 equals 170 or greater then q2 turn red and bold or if d2 has a "S" and the formula in q2 equals 300 or greater then turn red and bold. In english if a person is type C than they can not go over 170 and if they are type S than they can not go over 300. I don't want to have to sort by C & S then apply a conditional format. Please help, I've been frying my brain on this spreadsheet.