Cell Formatting Colours by Value

[MTBer]

Sat my MOUS Expert today and something came up that I had never seen o
heard of before.

A cell had to be formatted to be red if below a value and includ
brackets, whilst above the value it was coloured blue and withou
brackets.

This didn't use Conditional formatting, but was a custom format.

I solved it by manipulating an already present custom format, bu
really need to know how to do it now.

Thank

 

[Frank Kabel]

Hi
within custom format you can define up to three conditions to
differentiate custom formats (and include a font color). See the Excel
help for creating custom formats