Hey Guys.
I was wondering if someone could help me. I am trying to write this little
budgetary analysis tool for my boss... It does everything I need it to so
far... pulls the data... cleans it ... performs an analysis and a forecast...
but he wants it to be a little more visual/aesthetically pleasing... So, I am
trying to create a red light, yellow light, green light graphic for him ...
I need to write an excel formula for a few cells that will compare two
numbers and color the cell appropriately based on the comparison.
I want it to be something like this:
=IF(A1>B1, color the cell green, IF(A1=B1, color yellow, IF(A1<B1, color
red, else color white)))
How do you change the color in the cell using an excel formula?
I greatly appreciate any assistance you could offer.
Thanks,
-Michael
Bookmarks