I am doing exactly the same as you have demonstrated and am getting the "Error : you cannot use references to other worksheets or workbooks for conditional formatting criteria"
I am not able to compare two excel sheets. Error is showing as : "You cannot use references to other worksheets or workbooks for conditional formatting criteria" Sir, please give solution.
You may not use references to other worksheets or workbooks for Conditional Formatting criteria...if i am using ur said method for compare what is the solution for this
Bhaiya mere pas 15 sheets ki ek file hai... usme se mai ek sheet se kuch Entry delete krke kuch formatting kr ke Us sheet ko ready krta hu toh... mai Chahata hu ki Jo Maine ek seet m kaam kiyaa wo ek sath Sb m ho Jaye..???
Sir Excel ka 2 file hai jisme name father name , mobile number toh isko match karke dekhna hai ki same log toh nahi hain dono sheet me but ek naame ke bahut log hain name and father name dono match karna hai kaise karenge
i have two spared sheets one is called stock with price and another is called calculator in a stock sheet there is 3 columns category and sub category and price that shows in calculator sheet in list form i am not able to get a specific price of category and subcategory wise ex fruit is category and apple is sub category and 100 is price in calculator sheet fruit and apple are showing but how can i get the price of it please help me............ looking to hear from you..
If I have some values in one column 0.0, 0.81, 1.25, 2.50, 3.50 but we want print to other column 0 to 0.5 through if condition so plz suggest formula sir ji or any guys
SIR YE EXCEL 2007 ME WORK NHI KRTA HAI KYA SIR OR SHEET KA RENAME CHANGE KIYE HAI KYA USSE SIR ERROR TO NHI RHA HAI NA SIR SHEET 2 REFERENCE DOES NOT EXIST KRKE SIR AISA KUCH LIKHA HUA
Hi Team, I need solution here lets say I have 4 cloumns a,b,c,d I want to look for a value of a1 in entire c column if it matches then I need to print the value which is difference of b-d(d is row which matched a & c). Thanks in advance for helping.
Dear Sir, I am not able to compare two sheets. Getting error message….There are number of guys who have mentioned that error. Please help to solve that. It’s very useful but right now we many are facing problem. Kindly help. It’s urgent
Hi sir, it is showing an error of “You cannot use references to other worksheets or workbooks for Conditional Formatting criteria “ Please guide sir about this
Very nice ....aj mere boss n yhi kaan diya tha maine 4hrs 😂😂lgaye
Thank You Sir❣
Thank you its working❤
Welcome 👍
धन्यवाद साहेब तुमचे खुप खुप आभार 🙏🙏
Thank you so much.This video helped me a lot in my project.
Well explained👍
Very good sir and useful
Thanks bro it worked.
Thank you so much ,very usefull and working
Very interesting and informative!!
Glad you enjoyed it
Thanks bro it worked
Very nice. I like it. It's useful.
Nice video keep it up brother
I will try my best
good lesson! would love to learn more excel lessons from your channel
More to come!
This vedio is very useful. Can we compare more than two sheets?
Yes. But in third sheet you have to apply conditional formatting again
Which Excel version u r using ?😊
Very useful 👌👍👍👍
Yes.
Very useful video,
You're Welcome. Keep Sharing 🔃♥️👍🏻
Well done sir
Very informative
Glad it was helpful!
Osmmm👌
Keep Sharing 🔃♥️
Thanks a lot sir jee
Your Welcome. Keep Sharing.
Thanks 👍 information & download practice Link 🖇️🔗
Link given in Video description.
Kya hum 2 data sheet me se capital or small laterr ko bhi highlight kr skte h
Very nice and thank you. Sir can we compare two work book data? Plz tell me!!
I am doing exactly the same as you have demonstrated and am getting the "Error : you cannot use references to other worksheets or workbooks for conditional formatting criteria"
Yes mine also
Because you are comparing 2 files but in video shows 2 sheets within the same files. Just copy paste content in Sheet2 in same file and check.
@@piyushvadhel2065I have did what you said....but it's not working ...
Sir tall data vs 2b data kese match krte hai uska koi vidoe
How to fill all missing value in sheet two from sheet one pls. Help
Thanks
I am not able to compare two excel sheets. Error is showing as : "You cannot use references to other worksheets or workbooks for conditional formatting criteria" Sir, please give solution.
same problem with me
Same issue
Same issue facing
Same issue
Same problem with me
Good
Thanks
Sir Andriod Sheet ya Excel App mai ye kesy krnegy uska b bta dy plzz
Well explained however cannot see the video as it was blur
Thanku
Fine
You may not use references to other worksheets or workbooks for Conditional Formatting criteria...if i am using ur said method for compare what is the solution for this
You may not reference to other for conditional formatting criteria how to solve this problem??
It can only compare the value ??
Cells
Bhaiya mere pas 15 sheets ki ek file hai... usme se mai ek sheet se kuch Entry delete krke kuch formatting kr ke Us sheet ko ready krta hu toh... mai Chahata hu ki Jo Maine ek seet m kaam kiyaa wo ek sath Sb m ho Jaye..???
Power Query.
Do work on NSE Report file
Like?
It data is up and down in second sheet then how can we compare..please prove the formula
Sir Excel ka 2 file hai jisme name father name , mobile number toh isko match karke dekhna hai ki same log toh nahi hain dono sheet me but ek naame ke bahut log hain name and father name dono match karna hai kaise karenge
i have two spared sheets one is called stock with price
and another is called calculator
in a stock sheet there is 3 columns category and sub category and price
that shows in calculator sheet in list form
i am not able to get a specific price of category and subcategory wise
ex fruit is category and apple is sub category and 100 is price
in calculator sheet fruit and apple are showing but how can i get the price of it
please help me............
looking to hear from you..
साहेब या मध्ये फक्त नंबर compare होतात name nahi
If the serial is not maintained than how to compare
If I have some values in one column 0.0, 0.81, 1.25, 2.50, 3.50 but we want print to other column 0 to 0.5 through if condition so plz suggest formula sir ji or any guys
I think you have to first divided that information in another cells
SIR YE EXCEL 2007 ME WORK NHI KRTA HAI KYA SIR OR SHEET KA RENAME CHANGE KIYE HAI KYA USSE SIR ERROR TO NHI RHA HAI NA SIR SHEET 2 REFERENCE DOES NOT EXIST KRKE SIR AISA KUCH LIKHA HUA
Hi Team,
I need solution here lets say I have 4 cloumns a,b,c,d
I want to look for a value of a1 in entire c column if it matches then I need to print the value which is difference of b-d(d is row which matched a & c).
Thanks in advance for helping.
=IF(COUNTIF(C:C,A1)>0,"found","not found")
Windows 7 , office 2007 mai not working. Showing message - "conditional formatting not work for different sheets"
Please Upgrade your office Package
Dear Sir, I am not able to compare two sheets. Getting error message….There are number of guys who have mentioned that error. Please help to solve that. It’s very useful but right now we many are facing problem. Kindly help. It’s urgent
You can't use references to other worksheets or workbooks for conditional formatting criteria.
Please anyone who know how to solve this please help me
On pressing F4 the $ sign is not going
Same issue
Same issue ..
Will it be applied on name?
Whatever written in cells
👍
감사합니다 선생님
Jo difference wo alag sheet mein populate karne ho toh
🙏👍🤗❤️
❤👌👍
Hi sir, it is showing an error of “You cannot use references to other worksheets or workbooks for Conditional Formatting criteria “
Please guide sir about this
Not working for me
Nahi ho raha hai.
getting an error sir
Not ise full
Not working
Kaam nhi kar ra
I need some help regarding excel can I contact you on insta????
Not working