Conditional Formatting in Excel 2007

[didi]

Hi guys,

I have been asked to prepare a spreadsheet that uses conditional
formatting on another cell. What it needs to do is that is a cell
contains a particular value i.e. between 2 and 6 the adjacent cell
will turn say blue, but the issue is that there is up to 6 different
rules that could be applied to that one cell. All of these rules then
need to work for the subsequent entries.

If anyone could help me with this issue I would be very grateful.

Many Thanks

Didi

 

[TheGlimmerMan]

Hi guys,

I have been asked to prepare a spreadsheet that uses conditional
formatting on another cell. What it needs to do is that is a cell
contains a particular value i.e. between 2 and 6 the adjacent cell
will turn say blue, but the issue is that there is up to 6 different
rules that could be applied to that one cell. All of these rules then
need to work for the subsequent entries.

If anyone could help me with this issue I would be very grateful.

Many Thanks

Didi

see if the conditional formatting in this workbook will help you...

http://office.microsoft.com/en-us/templates/resistor-value-decoding-tool-version-2-TC102182467.aspx