Use different cells for conditional formatting on same row
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.
BundlesForImage.xls
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.
BundlesForImage.xls
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
oh, I get it, the first entry in the list is just no formatting, then use the other three. COOL
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER