Please be very clear in what you tell me to do as I am just learning. Also,
we are waiting with baited breath for your words of wisdom and checking this
site every 5 minutes :)

"donnaK" wrote:

I have written an IF function where the true value is a Lookup function. I
would like either the cell background or the text to format in Red if the
Lookup portion of the IF function is utilized (this would be the value if
true portion). I cannot use Conditional Formatting as my function refers to
different workbooks. Correct?