Conditional formatting on Clipart/Shapes

  • Thread starter Thread starter Sandip
  • Start date Start date
S

Sandip

Hi,

I am trying to be little creative in trying to present our financial
statements pictorially and conditional format it depending on how we
stand against Budget.

I would like a Clipart or Shapes in the form of a human body. The head
represents the Rev or Net Revenue, the body represents the Costs/Opex
and the legs represents the Margin and Margin %.

The body can be bifurcation into smaller parts which can represent
different cost elements.

Depending on how we stand against budget, i would like the body colour
(different parts of the body) to be coloured in Red or Green via
conditional formatting since the status can change month after month.

Is this possible. Let me know otherwise i can also do something which
are ordinary and easily possible.

Regards
Sandip.
 
Say your picture is actually a set of sub-pictures, each cleverly aligned to
appear as one picture.

You could then write a macro to selectively set the indiviual sub-pictures
to either Visible or not.

So the macro could make the head invisible and leave the body visible.
 
Hi,

On a totally different note: Will management think this is a cute as you
do? In general, this kind of creativity is not well recieved by the audience
unless they are kids. I applaud your creativity but question its
applicability.
 
Back
Top