It's so simple and yet i can't figure it out! Help!

Posted by John on January 17, 2002 7:02 AM

I have this line:

=IF(OR(ISBLANK(B4),ISBLANK(C4),ISBLANK(D4),ISBLANK(E4)),"Enter ALL Details","Complete")

How can i make it so that "Enter ALL Details" comes up in white writing in a red cell and "Complete" as white writing in a blue cell?

Posted by Dave on January 17, 2002 7:10 AM

select the cells with the formula's in then:

format>conditional formatting

set it up so it reads something like: "cell value is equal to Complete" then hit format and select font colour etc.

hit ADD and do the same for Enter ALL Details.

There you go!

Dave (Happy not to be the one askig questions for once :) )