Using Ecel formula to change a cell'sfill color

[Brooklynguy]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I am using Excel for Mac (v. 12.2.3). I want to change the fill color of a cell's content dependant on whether this cell's value is outside a specific range, say 90 to 120, AND whether a second cell's text contents say "pre-meal.

If this is outside the range, I want the cell's value to change to red, otherwise do nothing.

I cannot find anything in Excel's help section.

Thanking you in advance (despite Mr. Sanger's teachings),

BG

 

[CyberTaz]

One Option: Use Format> Conditional Formatting.

Assuming you actually meant "outside a specific range, say 90 to 120" set
the left list to Formula Is then enter the following formula into the
adjacent field:

=AND(OR(A1<90,A1>120),B1="pre-meal")

Click the Format button, select the Shading Color as well as formatting for
Font & Borders of your choice.

HTH |:>)
Bob Jones
[MVP] Office:Mac