Us the IF() function to check for the same conditions that turned the cell
yellow.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Tim" wrote in message
...
Can I use if funktion when the logical test is not value?

I have conditionally formated the cells C7:J48 such that if some
conditions
apply then one (only one) of those cells will turn yellow.
Now, I want that another cell H63 to pick up the value of yellow cell.
Can I do this whith if function?
Or any other possibilities?

TIA

Tim