Me.Value
We can use this "trick" to then quickly handle cell / font formatting.
=IIF(Me.Value < 0,"IndianRed","DarkSeaGreen")
This will be a great time saver, as it'll mean you don't have to lookup the cell name each time you want to perform a conditional format.
eg.
=IIF(ReportItems!Textbox1.Value <0, "IndianRed","DarkSeaGreen")
No comments:
Post a Comment