Hi,

Apply a conditional format to these formula cells

Select on of them and then

Format|Conditional format
Select 'cell value is'
select 'Equal to'
enter Pass in the box and pick your colour

Click ADD and repeat the process for Fail.

Mike

"clipski" wrote:

Hello,

I have a simple If statement that results "PASS" if the statement is
true and "FAIL" if the statement is false. Is there a way that the
result can be automatically highlighted as well. I want "PASS" to be
in Lime green and "FAIL" to be in RED.

Thank you,