Hi All,
Attached is an example of what I'm trying to create.
1st requirement: If B1 is % then the variance calculated in A4 should be in % and if B1 is absolute values then A4.
2nd requirement: If A4 is below 0, both if % or absolute value, then it should be red text color. If above 0 it should be green
Please help,
thanks!
Last edited by algl05ab; 06-19-2015 at 05:37 AM.
Hi,
See the attached file.
fantastic!
You are welcome
If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.
Also, you can directly thank those who have helped you by clicking on the small * (star) icon located in the lower left corner of a post that you have found to be helpful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks