I have a spreadsheet that someone who is no longer working for us set up.
They set up a column of cells to change different colors depending on the
number value in that cell. (Current Example: If the number is between 5-7
the cell turns green) I need to change the cell to change to green if the
number is between 5-6.75.

Does anyone know how to do this?

Sincerely,

Michelle

Shel Bell,
Two ways this function can be achieved. One through programmin
(macros) and one through the Excel feature called Conditiona
Formatting. I suspect that it is the latter.
Try selecting the cells that behave this way and go to

FORMATCONDITIONAL FORMATTING

This should bring up the conditional formatting dialog and you shoul
see something like:

Cell Value Is Between 5 7

Change the 7 to 6.75

HT

--
Case

-----------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...nfo&userid=454
View this thread: http://www.excelforum.com/showthread.php?threadid=55732

Thanks Casey! It Worked!

"Casey" wrote:


Shel Bell,
Two ways this function can be achieved. One through programming
(macros) and one through the Excel feature called Conditional
Formatting. I suspect that it is the latter.
Try selecting the cells that behave this way and go to

FORMATCONDITIONAL FORMATTING

This should bring up the conditional formatting dialog and you should
see something like:

Cell Value Is Between 5 7

Change the 7 to 6.75

HTH


--
Casey


------------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=557326

Conditional formatting. See http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Shel Bell" <Shel wrote in message
...
I have a spreadsheet that someone who is no longer working for us set up.
They set up a column of cells to change different colors depending on the
number value in that cell. (Current Example: If the number is between
5-7
the cell turns green) I need to change the cell to change to green if the
number is between 5-6.75.

Does anyone know how to do this?

Sincerely,

Michelle