Hi there,
I'm a conditional formatting n00b and can't seem to find an elegant solution to my problem - I'm sure its trivial, but its eluding me at the moment.
What I'm doing is tracking projector bulb life over time.
in my spreadsheet, I have several columns, each representing a different projector. The second row is the theoretical maximum bulb life of the projector - then each month is the current hours that the projector is up to
something like this:
Epson Max Bulb Life (hours) 3000 Jan 200 Feb 400 Mar 550
So I wanted to jazz up the sheet with some conditional formatting by overlaying some colour bars that are a percentage of the listed max bulb life - to help indicate how close to the max hours each projector is up to, but I'm not familiar enough with the syntax to make this work elegantly.
I can get the effect in an adjacent column, but not on the column of hours itself - I'm just a little unsure of how to embed that formula into the conditional formatting.
eg
colourbars.PNG
What method(s) do I need to use to create the effect I'm after - and also be able to keep adding on new rows each month and have the formatting carry on.
Appreciate any hints / tips / ideas
regards
Malcolm
Bookmarks