Sir,

I want to know whether one can create an alert in excel spread sheet, for which I enclose a sample sheet for reference.

The sample sheet has some data built on the model of a stock inventory. In the first worksheet (stock table 1), the inventory of stock as on the second week of December 2012 (15.12.2012) is shown. In the second worksheet (stock table 2), the inventory of stock as on the third week of December 2012 (22.12.2012) is shown.

The receipt and issue of stock during the week are posted in the second sheet.

In this regard, it is requested whether an alert can be created on the excel sheet (in second sheet 2) for the closing stock over the available parameters viz. 1day stock to 3month stock shown in Green coloured columns, H to L.

As soon as the closing stock comes below the available parameters viz. 1day stock to 3 month stock, the alert has to function and exhibit the same. This may be either being exhibited as coloured cells or blinking cells as shown as result in sheet 2. (Stock table 2)

shree18

Use conditional formatting.

1) Highlight H2:K6

2) Apply a Conditional Formatting rule of:
=AND(H2<=$G2,I2>$G2)

3) Highlight L2:L6 and apply a conditional formatting rule of:
=L2<=$G2

Quote:

---

Originally Posted by JBeaucaire

Use conditional formatting.

1) Highlight H2:K6

2) Apply a Conditional Formatting rule of:
=AND(H2<=$G2,I2>$G2)

3) Highlight L2:L6 and apply a conditional formatting rule of:
=L2<=$G2

---

Thanks sir
shree18