In a cell I have a drop down list of either Yes, No or ? (C2). Depending on which of these is chosen, that entire row is highlighted a different color. (I only used two conditional formatting for this because 'NO FILL' is a color too, white) I want to be able to also look at cell F2 and if it = YES, I want that entire row to be bold.
Trouble is, that if cell C2 = No and the row turns grey, AND cell F2 = Yes, nothing happens for that condition. It is like conditional format can only do one format per row.