Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Question
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Question | Excel Discussion (Misc queries) | |||
Conditional Formatting Question | Excel Discussion (Misc queries) | |||
Conditional Formatting Question | Excel Discussion (Misc queries) | |||
Conditional formatting question | Excel Discussion (Misc queries) | |||
Conditional Formatting Question | Excel Worksheet Functions |