The cells C7:J48 are divided in 8 columns and the cells in these colums have
not the same conditions. (Have not been equally conditionally formated) All
these conditions cannot be put in a simple "if" formula.
I wanted initially to use match() funktion but I am not very familiar with
it, so I was thinking it would be easier if I can use if() funktion with
logical tests such cell color or any other format element.
"Sandy Mann" wrote:
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