I am trying to format the error percentages. So if the value is closer to zero, cell background should be greener. If a value is far from 0, cell background should be more towards red side.
I have about 60 cells which I want to format and my errors percentage genally fall between -50% to +50%. So I dont want to create fixed rules likeHow do i achieve this in excel 2007.![]()
Please Login or Register to view this content.
Bookmarks