I am using the following formula.
=IFERROR(INDEX(Data!M:M,MATCH($B$3,Data!R:R,0)),"")
It works great BUT 1 thing. The Data on M:M row is all in red. When it comes over to the other worksheet it comes in black. I want it to stay red. It that possible?
Short answer, no. Unless the font on the Data sheet is a result of Conditional Formatting and you can replicate the CF.
Or maybe with VBA?
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks