But you could use a worksheet EVENT that actually changes the font color
and/or the fill color the way you want.

Dave Peterson wrote:

First, you can specify the Fill color--choose it on the pattern tab.

Second, if you're gonna stick with format|conditional formatting, you're stuck
with 3 conditions.

But you could use a worksheet that actually changes the font color and/or the
fill color the way you want.