cell to change color =IF(B7>53,"Critical","Normal")

[fgiord]

I need to have a cell change color or flash when the water level reaches a
certain critical depth on a pumping spreadsheet so the operator is aware of a
problem!

[swatsp0p]

To change the background color of your desired cell: select that cell then click Tools>Conditional Formatting... on the main menu.

In the Conditional Formatting dialog box that opens, choose Formula Is: and enter this in the formula line:

=B7>53

click on the Format button, click on the Patterns tab and choose your desired fill color (with Red fill I also like to change the font color to Yellow and make it Bold-use the Font tab for this).

click OK twice to exit the CF box.

now, whenever B7 exceeds 53, your cell will change to your selected format.

HTH

Bruce

[Bob Phillips]

Select the cells.
Got to Format>Conditional Formatting
Set the condition to greater than 53
Click Format
Select Palette tab
Choose a colour
OK
OK

--

HTH

RP
(remove nothere from the email address if mailing direct)


"fgiord" <[email protected]> wrote in message
news:[email protected]...
> I need to have a cell change color or flash when the water level reaches a
> certain critical depth on a pumping spreadsheet so the operator is aware
of a
> problem!

[RagDyer]

You can use Conditional Formatting, and set it so *both* B7 *and* the cell
containing your IF() formula will change color, so that the number in B7 >
53 and the text "Critical" will highlight.

Click in B7, hold down <Ctrl>, and click in the cell containing your IF()
formula, then:

<Format> <ConditionalFormat>

Click "Formula Is", and enter this in the formula box:

=$B$7>53

Then click on "Format", and maybe set the Pattern to red and the Font to
bold and bright yellow, then <OK> <OK>.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"fgiord" <[email protected]> wrote in message
news:[email protected]...
> I need to have a cell change color or flash when the water level reaches a
> certain critical depth on a pumping spreadsheet so the operator is aware
of a
> problem!