Conditional Formatting in Excel 2007

  • Thread starter Thread starter didi
  • Start date Start date
D

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
 
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
 
Back
Top