Conditional formatting with colours set in a cell

[ohowson]

I'd like to do a conditional format, but rather than hard coding the colour into the formatting rule, I'd like to say (eg) IF value = 3 THEN set font colour to the value in A4

Is this even possible?

[arthurbr]

Hi
with VBA most certainly