Assalaam alaikum, it's a nice video......i have been learning Conditional formatting for last 1 week and it really helped me to gain more knowledge about conditional formatting..........thanks for this video.
Thank Haneef, Nice video. Please share some content about how to use conditional format for numerical data. How cell can be Mark in different colors if score or % of achievement if leass than 80%.
Hi., Mai ek banker hoon... Apki badi meharbaani hogi... Yadi aap iss tarah se date k liye kar k dikhayenge to... I want if one date is more than 2 years from the date in other cell it should become red. Please show this..
What is the formula of cell greater then previous cell number and change the colour , if cell greater then or lower then previous cell , can change the color
Thankyou for this video sir ...but can you please help me with this query Agar Pakistan ho tho adjacent column cell violet hona chahiya agar America ho tho uska adjacent cell should be green
Sir i have seen and searched lot of videos and playlist for my query but not found suitable solution. actually i want to shift a row automatically up or down on the basis of dates and grade or cast. For example my name is placed on 5 row as worker or on the basis or appointment seniority and i was promoted to the post of Manager. Here i would like that when i changed the post and date of promotion my data automatically move top of the list on seniority one.
R/Sir, इसी तरह बहुत सारे column के लिये automatic highlight करने के लिए formula बताइये, क्योकि इस तरह तो बहुत सारे columns के लिए बहुत time waste होगा। please tell me. Thanks
hi sir Agar kisi emplye ki date of jining 25/01/2019 hon ya kuch bhi date ho XYZ tu main chata hon k monthly mojhe excel remind karaye k 25 salary pay karne ka day araha ha same day remind kara day ya 3 din pahle asa koi fprmula ha jo har month ki koi ek date ko koi bhi date jo hum chate hain remind kara day please help.
Sir G asslam o alaikum me conditional formating banana chahta ho. meri ak shop he jis me mere pass rate box and pcs k hisab se aate he faraz karen agar me pcs ka rata lagao to box ka khuda ba khuda aajae.. kiya ye hoskata he?? reply ibyounism@gmail.com