I think conditional formating can help you.
select the cell, click formatconditional formating and enter the
values/formula

"color blind" wrote:

Can some one help me...I need to change either the color of the font or the
color of the cell in a logic formula...Thanks