Conditional Formatting using AND()

[ilcaa]

I have 3 values in separate cells... i am comparing 1 cell to 2 cells. Within a cell i can write =AND(D10>D9,D10>D8) and I get FALSE or TRUE depending on numbers

BUT if i use the same formula in Conditional Formatting it doesnt produce a colored condition... how can i apply a conditional formatting when comparing multiple cells to 1 cell?

thanks

 

[Fluff]

Can you post some sample data using the XL2BB add-in that shows the problem?

 

[Peter_SSs]

BUT if i use the same formula in Conditional Formatting it doesnt produce a colored condition.

It does for me

23 06 14.xlsm
	D
8	5
9	2
10	6
CF AND

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D10	Expression	=AND(D10>D9,D10>D8)	text	NO

Perhaps you could explain in words in more detail exactly what you are trying to do?

 

[Joe4]

I have 3 values in separate cells... i am comparing 1 cell to 2 cells. Within a cell i can write =AND(D10>D9,D10>D8) and I get FALSE or TRUE depending on numbers

BUT if i use the same formula in Conditional Formatting it doesnt produce a colored condition... how can i apply a conditional formatting when comparing multiple cells to 1 cell?

thanks

This may sound silly, but I have seen people forget to do this (including yours truly once or twice).
DON'T forget to set the desired formatting you want after you enter the Conditional Formatting rule/formula.
It is easy to get so wrapped up in getting the formula right that you forget that part.