Basic Conditional Formatting Question.

[JulieG]

I would like to place conditional formatting on column A based off of the quotient of rows B and D.

I have applied my formulas (=AND(D2/B2<=.15,D2/B2>0). The fomula is accepted and formatted. However its not changing column A accordingly.

Now Column a contains text.. Could that be the problem.

Running Excel 2007!

Thanks
Julie

 

[jbeaucaire]

Works for me in column A. Since there is no test OF column A, it doesn't matter what is in the actual cells being colored. Are you sure you set your color properly? If you want to test the formula directly, put that formula in a regular cell. It should return TRUE when true and FALSE when false, which let's you know how CF is going to see it.

=AND(D2/B2<=0.15,D2/B2>0)