MS OFFICE EDITION 2003
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
"Bill" wrote:
Using EXCEL, I want to color code a cell if its value is "x" times another
cell's value.
Any answers?
|