Steve,
To spice up things within my conditions I want to add one extra calculation.
The formula is great, however, I need it Row 19 to be multiplied by 1000
(onethousand) before row 31 calculates the percentage increase. Any ideas?
for instance;
=AND((B31-B$19)/B$19*1000=26%,(B31-B$19)/B$19*1000<=35%)
"SteveG" wrote:
If you want to have it color yellow if the % is between 26% and 35%
(including 26% & 35%).
=AND((B31-B$19)/B$19=26%,(B31-B$19)/B$19<=35%)
The formula for red that Bob gave stays the same. This will cause the
cell not to fill with any color if your % falls between 35% and 36%.
Cheers,
Steve
--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=487940