B Bill Sep 18, 2008 #1 Using EXCEL, I want to color code a cell if its value is "x" times another cell's value. Any answers?
Using EXCEL, I want to color code a cell if its value is "x" times another cell's value. Any answers?
M Mike H Sep 18, 2008 #2 Hi, Select a1 then Format|Conditional format Select 'cell value is greater than' enter the formula =$C$6*10 Pick a colour OK When a1 is <C6*10 it changes colour. Mike
Hi, Select a1 then Format|Conditional format Select 'cell value is greater than' enter the formula =$C$6*10 Pick a colour OK When a1 is <C6*10 it changes colour. Mike
G Gord Dibben Sep 19, 2008 #3 Conditional Formatting>Formula is: =A1=5*B1 Format to a nice color and OK Gord Dibben MS Excel MVP
