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.

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.

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.

One way is to use
Format Conditional formatting
Cell value is greater than 700000


... Also, I want to
apply this conditional formatting across multiple cells

This conditional format can be copied using the "format painter" brush.

(I have Excel 2003.)