Hi,
Anyone one can help and advice
I want to show color bar or icon bar in the amount for reminder column for amount that are over and under spend. Is there any way to do it?
I try with Conditional formatting but cannot get the result I wanted. Please advice the steps.
excel.JPG
The Data bar conditional format can display positive and negative bars.
Attachment 675276
Just seen you posted this in the Word forum. Did you want the bars in a Word document?
hi Andy
As per the image, I want to have color bar inside Column C where all negative with number in red and under spend with number in blue.
Attachment 675922
thanks
You image reports as invalid and does not show
What has any of this to do with Microsoft Word?Originally Posted by bbsin
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks