Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Copy cell colour if number match

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)