Conditional Formatting Question

[Romeo3891]

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.

 

[JBeaucaire]

Use this instead:

=(2000000/F13)<0.35

 

[MyVeryOwnSelf]

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.)