View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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?