Change cell fill color dependent on formula result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet created by someone else. When the calculations are done,
the cell color turns red if the resulting percentage is greater than 45% and
green if it's less than 40%. I have tried to figure out how this was done,
but without success. Help!
 
Helen,

This is feature of Excel, known as conditional formatting. I wasn't aware
that the feature imported into PPT.

Within Excel, <format menu, conditional formatting>.
The conditional formatting dialog box, allows you to set up to three
conditional statements for each cell or cell range. The conditional statement
must evaluate to a true or false answer.

There are a series of pre-defined conditions:
cell value is , <between> value 1 and value 2
cell value is , <equal to, etc.> value 1
cell value is , <etc.>

or you can use create a formula as the conditional statement.
Formulas allow you to test for multiple and simultaneous conditions.

Although, the conditional formatting dialog box tells you that you are
testing for only three conditions, you are actually testing for four. The
fourth state is the neutral state, or when all three conditions are false.

If condition one is true, then you can change the the cell's Pattern(color
or pattern fill) , font or border characteristics.
 
Just to confirm:

Within a PowerPoint 2007 slide, if you Insert>Object>MS Excel Worksheet, to
embed a spreadsheet, the Conditional Formatting features DO work on the
embedded spreadsheet.

wam
 
Thanks, Tom. I forgot which newsgroup I was in when I wrote this question.
Glad someone in the PPT world was willing to answer it for me!
 
You are Welcome.
I was happy to help, and I learned a new fact,that conditional formatting
carries over into ppt. Thanks to wamiller36.
 
Back
Top