Multiple conditional formatting

Hi.

I have attached an example of my sheet to explain myself better.

In this example I have made a scroll bar to view my data. Since there are three different categories in this example ("Income", "# Clients" and "Product %") in the same column, I need to format them differently when scrolling up and down to suitable formats. I.e. €, number or % and I need the format to be applied/changed depending on what is being shown in those cells.

I have made a conditional format example in cells H4-H7 and formatted them to € if cell I4 ="Income". The problem is that when scrolling up or down, the € format does not go away if cell I4 doesn´t = "Income". It´s like the conditional format doesn´t "care" if cell I4 is "Income" or anything else, but formats the cells to € no matter what.

I need to find a way to apply multiple conditional formats to format the cells according to what is shown (€, numbers or %).

Does anybody have any suggestions/solutions to this? Any suggestions are highly appriciated.

Thanks in advance.

Hi
Could you please save a copy in 2003 as I only have that on this thing,
regards
peter

Hi Peter.

Sure, I´ve attached it. Thanks for having a look at it.

Cheers.

I'm not sure if this is what you are after or not, there wasn't any cond form in column h
I wasn't sure what you needed doing with the error message in h
regards
Peter