Use this instead:

=(2000000/F13)<0.35
--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Romeo3891" wrote:

Hi, I am trying to set up conditional formatting in a particular cell -- what
I want to do is have the cell turn gray if 2,000,000 divided by the value in
the cell is less than 0.35.

I currently have as the formula in the "formula is" section

= "(2000000/$F$13)<0.35"

and I formatted it so that the cell is supposed to turn gray when this value
is true, but for some reason this does not work. Also, I want to apply this
conditional formatting across multiple cells, which hopefully should not be a
problem. Excel seemed to default to the "$" cell holders for the column and
row when I selected cell F13, but I am sure I can probably get this of this
as well and apply this formatting across multiple cells.

Appreciate any help -- thank you.