How do I colour ill a cell in excel with a formula?
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
|