LinkBack URL
About LinkBacks
Hello guys,
i am using the below Macro (found it on pk-anexcelexpert.com) to lookup value but I am getting #VALUE! error, but when i use this macro on a new sheet it works fine .any help please.
Please Login or Register to view this content.
Hello guys,
i am using the below Macro (found it on pk-anexcelexpert.com) to lookup value but I am getting #VALUE! error, but when i use this macro on a new sheet it works fine .any help please.
Please Login or Register to view this content.
Can you explain how it should work...!
In your example, if M5 has the same color than S5 value result is "Bank Holiday" is it ???
- Battle without fear gives no glory - Just try
Cell "M5" has Conditional Formatting and cells "S5:T5" are normally/usually/ordinary formatted - therefore the function does not work.Originally Posted by ismailshajji
Last edited by mjr veverka; 11-10-2019 at 03:09 PM.
After a first review, it seems that
is disturbing the functionPlease Login or Register to view this content.
What is the purpose of this macro ??
I am planning to implement this with the Annual leave spreadsheet . Using the conditional formatting the leave date will be highlighted with a specific colour.
For conditional formatting in the "r1" range and normal formatting in the "cel" range, the following code:
is incorrect.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks