Cell Formatting Question - Colors

[ststern45]

Good day everyone,

Have a question:
If this is possible.
1>Select a cell (any cell) A1 for example
2>I format the cell with a diagonal line from the right upper corner to left lower corner
3>Question: would it be possible to colorize just 1/2 of the cell below the diagonal line from the right upper corner to left lower corner?
Thanks in advance!!

 

[Fluff]

Whilst you can apply a diagonal border in the cell, you cannot put a fill colour into only half of it.

 

[ststern45]

Whilst you can apply a diagonal border in the cell, you cannot put a fill colour into only half of it.

OK thanks. Next question would be if I had an image of a cell where the left side was white and the right lower was blue. Would it be possible to enter a formula that in a helper cell that if the value in cell A1 was a 1 the image in cell B1 would be white left / blue right corner?
Thank you

 

[Fluff]

Something like that is possible. Search for Vlookup image.