Format Question

[dantheram]

If i have a cell where the value contained in it is changing (=OFFSET(A2,$A$24,$A$25,10,1), can i tell those cells to have different formats depending on the returned data.

I have %, currency and numbers to display in the offset cells.

 

[Ruddles]

I can't see a way of doing this.

Unless your percentage figure is always 100% or less and your currency figure is always more than £1.00. That would be simple.

There are better men than me on this forum - I'm hoping one of them will step in at this point.

 

[dantheram]

i concur, there is no way of doing this. although it seems relatively simple.