%formula in conditional formatting

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

Guest

Hi,
I have designed a sheet to measure staffs work times. In this sheet i put a
workrate time they need to work at and in a column their times are recorded
from other sheets. Using conditional formatting i want their times to turn
red amber green depending on if their time is within 5% higher or lower, so
red is 5% lower, amber is within either way and green is higher than 5%.
The reason for this is so that within the sheet all i have to do is change
the workrate figure and not go into conditional formatting function to change
each one to.
Hope this makes sense please help.
 
Try using something like this in the CF

=ABS(CellValue - Target) >= 0.05

I'm not sure how you want to do the colors based on what you've said, but
this should get you part way.

HTH,
Barb Reinhardt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting for cells with formulas 1
Conditional Formatting Traffic Light System 3
Conditional formatting dates 3
Excel 2003 Conditional Formatting w/ 3 Conditions and a value = to 2
Multiple Conditional Format 1
IF statements and conditions 2
4 conditional formats? 4
iF STATEMENTS WITHIN CONDITIONAL FORMATS 4

Back
Top