Hi all,

I too have a query about multiple conditional vaules, but this applies to the formula.

Say I want to check if the cells of two columns meet two conditions to apply the formatting to the corresponding cells of a third column:

If A1,A2,A3, etc is "not blank", & also if B1,B2,B3, etc have a value greater than 10. If both these conditions are met, I want to have the text of C1, C2, C3, etc turn White & the background of the Cell to turn Red.

How do I get both checks happening (if only one or the other case is true, I don't want anything to happen).

I've tried using:
=A1><""&B1>10

But this does not work.

I also need the Cells of the C column C1, C2, C3, etc to just have Bold Red Text if the corresponding "A cell" is "Blank" & the "B cell" is ">10"

I have multiple Conditional formatting rules to work, but can not seem to check for two rules applying at once.

Can anyone help me please?