Split a cell Diagonally and Treat Seperately

[DominicBell]

Hi,

I need to be able to split a cell Diagonally in Excel.
Each half needs to have it's own formula, and based on the value of the formula needs it's own colour coded conditional formatting.
I've looked for different add ins to allow me to do this but thought this forum may be the place to help with this?

Even if you can point me to a different product it would be much appreciated.
Thanks,
Dom

 

[AkaTrouble]

i am not understanding exactly what you are after

can you post a before and after sample giving us a better idea

regards

 

[Scott Huish]

You can't do that in a cell, the closest you can get is to format 4 cells to do that, 2 with diagonal borders and 2 with formulas.