Excel Conditional Formatting Based on Another Cell

[@travispitrat2163]

Thanks!

[@Syedhussainipage]

Thank you so much for the gratitude and the gift you have sent me Travis 🙇🏻‍♂

[@tommyharris5817]

BRILLIANT - explained much more clearly than others.

[@Syedhussainipage]

Thank you for the feedback Tommy, I genuinely appreciate it. The feedback helps in keeping me motivated. Kindly subscribe to my KZbin channel KZbin.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me. Best Regards, Syed H

[@paresh1233]

Your way of talking is very good. Very clear and crisp.

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@shabbs1234]

Could not agree more ... very nice presentation

[@shahalam-zf5yh]

Thank you sir

[@Syedhussainipage]

@@shahalam-zf5yh You're very welcome! Thank you for your comment.

[@JESJACKDAD]

Thank you. this will help me

[@Rapbiz]

Excellent

[@Syedhussainipage]

@@Rapbiz Thank you for the lovely feedback!

[@paresh1233]

Thanks very much helpful

[@Syedhussainipage]

Thank you for the feedback. I am so glad to hear that. Do subscribe to my KZbin channel kzbin.info for regular updates. Best Regards, Syed H

[@johnjastinkathanaparambile6240]

Thank you

[@ohnorthregions6624]

Hello Syed, I have problem with conditional formatting that I'm hoping you can help with. When I select a slicer heading "5.1 Team" and cell D4 in my pivot and apply conditional formatting, all is well until I go to my next slicer selection "Primary Care" and apply conditional formatting to a "different" D4. It then affects the formatting I applied to the previous "5.1 Team" D4 slicer selection. Is there a way to indicate that they are not the same cell? Perhaps adding the slicer reference? Background - I have created numerous dashboards based on one data source from a SharePoint list. The list also includes columns for the different slicers for each dashboard being created. Any help would be appreciated!

[@sajjadansari17]

Thanks for the information. Here I would like to know how do we get cell highlights date wise. Mean there is some date mentioned and I want the cell to be highlighted 1/2 week or a month before.

[@Syedhussainipage]

Sorry for delaying my response. Please share sample data so that I can take a closer look and help you with that. Use this form to submit your sample data file forms.gle/CxaWGeqdugMktWPx6

[@huzefa.a.hazari223]

Hello, The first step you showed, can show the same on GOOGLE SHEETS ?

[@varshapalande2217]

I have a question. Can we highlight rows based on row numbers and not based on the cell content ?

[@adrianalopez666]

I have a question, I have a sheet where I'm using several condional formats, highlighting the entire row, however for some reason is creating new rules with same conditional for only for specific cell, that I didn't not create or duplicating the one I did therefore the size of my file is increasing which is making hard to use. Beside deleting one by one, there's any way to avoid duplicating the conditional format.

[@Syedhussainipage]

Hello Adriana, Sorry for the delayed response. I was sick with COVID and hence the delay. Can you share a sample dataset with the requirement so that I can check it for you? Use this form to submit your sample data file forms.gle/CxaWGeqdugMktWPx6

[@babayaga5708]

Hello Sir, how to automatically highlight the entire Row by simply Input letter "L" stands for LATEST in single specific cell.

[@shakirabanulattannavar743]

Hi I have one scenario similar to this. Could you please help me

[@Syedhussainipage]

Please let me know how can i help

[@shanifkc1061]

Why do we need this long process...jst filter the specific item ..will get the entire coloumn and give colour

[@Syedhussainipage]

Thank you for sharing your thoughts. That is indeed another way of doing it. The technique I've discussed is to keep it there in action and trigger it whenever the condition meets.