Thread: Formula & Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nik_gujarathi[_7_] nik_gujarathi[_7_] is offline
external usenet poster
 
Posts: 1
Default 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