ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Formula & Macro (https://www.excelbanter.com/excel-programming/362572-formula-macro.html)

nik_gujarathi[_7_]

Formula & Macro
 

Hello friends
I have a formula in each cell of column L and R.
Example
Formula in cell L6 is =IF(J6<K6,0,1) & Formula in cell R6 is =
IF(P6<Q6,0,1)
I was looking for a macro that will give a error message "Warning" if
the value of cells in column L and R is 1


--
nik_gujarathi
------------------------------------------------------------------------
nik_gujarathi's Profile: http://www.excelforum.com/member.php...o&userid=34522
View this thread: http://www.excelforum.com/showthread...hreadid=546031



All times are GMT +1. The time now is 08:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com