change color of a cel 2 part questionl...

  • Thread starter Thread starter Dr,Bob
  • Start date Start date
D

Dr,Bob

I want to set up cells in a work sheet so the color will change
automatically if possible.
First I need some cells to change to green if I enter the letter Y otherwise
if the cell is blank or has any other letter inputed it will stay white.
2nd I need other cells to change red if the number entered is lower then a
referance number from a 2nd cell.Example cell A1 calculates the avereage
from cells B1 to H1. I need it so only if the number entered in any cell
from B1 to H1 is lower the the average calculated in Cell A1 will turn red.
Ie cell D1 turns red whenthe number is lower then the number in cell A1.
Can this be done? if so thanks in advance to all who answer
 
1. Assume the cell in question is K1, select K1 and do format>conditional
formatting, formula is

=EXACT(K1,"Y")

then click format button select either fonts or patterns and green, click OK
twice

2.

Select B1:H1 with B1 as the active cell, repeat formatting but use this
formula

=B1<$A$1




--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top