Conditional format: bar icon for dates

[Eukarist]

Hello,

I want to create a bar icon that reads the dates and as you run out of time the bars get less and less... like a cellphone battery...the more time I have, the more bars I have... I tried but I am not sure of what formula to enter... any help will be much appreciated

 

[fred]

try


REPT( " | ", end date minus now ( ))


every day when you open up the file it will refresh itself.

 

[Eukarist]

Hi Fred, where do I type this? I am under:

-format all cells based on their values, then there is a box with options for the bars:

-5 bars when value is >= (value) then type (formula)

-4 bars when <(value)

-3 bars when <(value)

-2 bars when <(value)

-1 bar when <(value)


I have passed dates, and future dates that go all the way to 2013 but I want anything more than let say, 2 months to have 5 bars and so on...


thank you so much!

 

[fred]

you need to replace "end date minus now ()" with a bunch of if-then formula and set it in such a way that satisfy the display of number of bars.


Basically, the end result should be a 1 to 5.


Or you can set a cell up by inserting an object via wingdings (or its sister sets). Reference that cell in the REPT formula and change the cell format where the formulae lie as wingdings as well.


See http://chandoo.org/wp/2011/03/16/analytical-charts-tutorial/ for details.

 

[Eukarist]

Thank you so much Fred, it works! I had to play around with it for a bit until I got it to what I wanted!