ExcelBanter - MS OFFICE EDITION 2003

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - MS OFFICE EDITION 2003 (https://www.excelbanter.com/excel-worksheet-functions/203078-ms-office-edition-2003-a.html)

Bill

MS OFFICE EDITION 2003

Using EXCEL, I want to color code a cell if its value is "x" times another
cell's value.

Any answers?

Mike H

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?

Gord Dibben

MS OFFICE EDITION 2003

Conditional FormattingFormula is:

=A1=5*B1

Format to a nice color and OK

Gord Dibben MS Excel MVP

On Thu, 18 Sep 2008 13:13:01 -0700, Bill
wrote:

Using EXCEL, I want to color code a cell if its value is "x" times another
cell's value.

Any answers?

All times are GMT +1. The time now is 11:45 AM.