conditional formatting

[fullymooned]

if a value in the cell is above 0.8 it should change the back groun
color of the cell to yellow

if the value is above 1.7 it should be red


thank yo

 

[Michael J. Malinsky]

Assuming you're evaluating the value in A1, then with the cell pointer in
A2, select Format>Conditional Formatting. Condition 1 should read "Formula
is" then paste the following into the box to the right:

=AND($A$1>0.8,$A$1<=1.7)

Select Format...then the patterns tab to select yellow. Click OK

Click the Add>> button. Condition 2 should be "Formula Is" then paste this
in the box to the right:

=$A$1>1.7

Select Format...then the patterns tab to select red. Click OK, then OK
again.

If you want to be able to copy and paste the formatting, then remove the
dollar signs from the above formulae to make them relative rather than
absolute.

HTH

--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain

 

[Frank Kabel]

Hi
have a look at 'Format - Conditional Format'
The following sites give you some starting information about this
feature:
http://www.contextures.com/xlCondFormat01.html
http://www.cpearson.com/excel/cformatting.htm

 

[Debra Dalgleish]

When you create the conditions in conditional formatting, put the
tougher test in the first condition. In your example, 'greater than 1.7'
is the tougher test. Numbers that don't pass that test will go through
the next condition -- greater than .8

Select the cell
Choose Format>Conditional Formatting
Leave the first dropdown as 'Cell Value Is'
From the second dropdown, choose 'greater than'
In the text box, type: 1.7
Click the Format button, and choose Red on the Patterns tab
Click OK

Click Add
Leave the first dropdown as 'Cell Value Is'
From the second dropdown, choose 'greater than'
In the text box, type: .8
Click the Format button, and choose Yellow on the Patterns tab
Click OK, click OK