conditional formatting for revenue drops

[tanya]

Is it possible with conditional formatting to highlight
product sales if they drop, such as 60 days 90 days and so
on, this needs to be sent to remote sales staff so they
can revisit accounts that have been flagged.

I've tried every type of format dell value is > 30, 60,
and so on, but nothing is working. If anyone has done
anything similar to this please let me know. this could
of course be written to work with increases as well as
decreases.

 

[David McRitchie]

Without a description of where to get the data cell addresses
we would be a disadvantage in answering your question.

You can read more about Conditional Formatting on my site:.
http://www.mvps.org/dmcritchie/excel/condfmt.htm

If you have to get a sum from a range you can use SUMIF
http://www.mvps.org/dmcritchie/excel/sumif.htm