Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

conditional formatting

0

hello, first of all sorry for my english and please open the attached excel file and look at cell G52 there, the percentage movement is 0% but why it has down-pointing red arrow instead of side-pointing yellow arrow?

the conditions i apply here are :

if the percentage movement > 0%, the cell has green arrow

if the percentage movement = 0%, the cell has yellow arrow

if the percentage movement < 0%, the cell has red arrow

please help me find the solution and thank you in advance.

Answer
Discuss

Answers

0
Selected Answer

Fida

Your formula in G52 is:

=ROUND(G50-G51,12)
which rounds the results to 12 decimal places! That's why what appears to ne 0% is formatted and a non-zero result.

Suggest you change it (and the other cells in row 52) to just 2 decimal places (so integer values of percentages) e.g:

=ROUND(G50-G51,2)
Hope this fixes your issue.
Discuss

Discussion

Thanks a lot John, your suggestion helps & works! The formula now is correct. 
Fida_mutia (rep: 28) Sep 19, '21 at 8:08 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login