Archive: MS Excel 2016 VBA code BEFORE REFRESH AND WORKBOOK OPENNING

Budget 21$ per month

Posted: 5 years ago

Closed

Description: Hello i have a MS Excel 2016 sheet with a macro written is does what it has to do, for Variance and Variance Percentage is must be GREEN when positive and RED when negative, that works fine, BUT the issue is the REFRESH as shown below. HOWEVER= 0 Then cell.Font.ColorIndex = 10
If cell.value = 0 Then cell.Font.ColorIndex = 10
If cell.value < 0 Then cell.Font.ColorIndex = 3
Next
Skills:
microsoft excel,software development,VBA programming language,Visual Basic programming language,workbook