Formatting
Posted by John P on January 17, 2002 5:39 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 Dan on January 17, 2002 7:12 AM
You can use conditional formatting.
In the cell that you have the formula in, goto to Format, Conditional Formatting.
In Condition 1, use Formula Is:
=OR(ISBLANK(B4),ISBLANK(C4),ISBLANK(D4),ISBLANK(E4))
and set the condition to white font, red background.
Add condition 2, use Formula Is:
=OR(ISBLANK(B4),ISBLANK(C4),ISBLANK(D4),ISBLANK(E4))=False
and set the condition to white font, blue background.
HTH
