Tried with absolute references to no avail. I cannot even change the cell
colors with the "Paint icon"
--
Glyn


"Gord Dibben" wrote:

Try with absolute references.

Select a range then FormatCFFormula is:

=$B$10<=$B$54


Gord Dibben MS Excel MVP

On Mon, 6 Oct 2008 12:18:05 -0700, Glyn
wrote:

I want the range to be green if B10<=B54. I went to Format/Conditional
Formatting/selected the color and on the dropdown selected Formula is and
entered =B10<=B54, said ok and nothing happened.