Programming Cells To Change Colors

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

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
>
> FORMAT>CONDITIONAL 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 [email protected]> wrote in message
news:[email protected]...
> 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