i want to create an system that can trigger alert which, the alert box will change to a red color depending on its value.
my problem is, the value that i used to compare is dynamic and based on what user key in in the paramater table while the data that will be display the alert is from the alert table.
lets say the value in the parameter table is been declare as A
and the value that display the alert is been declare as cellvalue.
this is the code that i have been trying
if cellvalue < A then
' some code to change the box color
End if
but i kept failing. the system cannot read the A value. please help.
many thanks in advance for those who are willing to help me :)
