Thanx Keena,
I tried this and its not doing anything. I used a target price of
$400.00 and an acutal price of $500 - and nothing happened - super
frustrating!
keeena Wrote:
I forgot to mention - select column "B" before opening the Conditional
Formatting window. This will apply the formatting to the entire
column.
keeena wrote:
Use conditional formatting under the Formatting menu.
Assuming Col A is the Targeted price and Col B is the actual price,
use
the following Conditional Format:
Choose "Formula is" option from dropdown
Enter this as the condition: =ABS($A1-$B1)50
Select the Format button and select the special format to apply
(e.g.
Yellow fill).
-K
--
SLO
------------------------------------------------------------------------
SLO's Profile:
http://www.excelforum.com/member.php...o&userid=35450
View this thread:
http://www.excelforum.com/showthread...hreadid=552262