I am using the below formula to see if, on one sheet the number matches on another one. What I also need to to copy to cell colour as well. Is that possible?
=IF(COUNTIF(Sheet2.A$1:$AK$99, E1)>0, TRUE,FALSE)
Thanks
Standard calc functions do not copy anything from one cell to another but evaluate cell content based on references (to cells, ranges, …) and other values (at least I’m not aware of any standard function to perform a copy). Hence no standard function copies a cells background colour to another. In fact it is even required to provide a custom function to evaluate the background colour of another cell.
The one first sheet is a map for pricing, the second is a filtered sheet with everything on the floor, filtered down from 12 pages to 3. What I need to do is try and figure out how to somehow she that certain cells on the first sheet need to use different labels. Any clue? I can change the cell to anything that will work.
Sorry, that’s incomprehensible for me without a sample file and clear "if this on cell x, then cell y should show…"-descripition(s) what you exactly want to achieve. You start talking about background colours (I’d agree with @erAck 's answer) and now I just recognize a new term “labels” (which btw. doesn’t tell me anything).
No. But you can use conditional formatting to apply a style depending on the result (or any other formula). See help.
I have looked at conditional formatting but it seems it doesn’t apply for what I need. I am seeing if the exact number is in another sheet, not with a certain range.
You can use conditional formatting to apply a colour to all exact matches, and a different colour (or no colour) to non matches. You cannot (easily?) pull the colour from another cell and use that within the sheet formula. If you were using a set colour palette for values on the other sheet you could apply the same colour palette to your conditional formatting, and this would achieve the same result albeit not in the manner you request.
It would be possible using macros, although reasonably non trivial.
Yeah, nice answer, i think its help for him!
This is not an answer, and it isn’t a useful comment either. What’s your intention?