# Excel Conditional Formatting Advanced Technique

Share
Embed
• Published on Mar 25, 2019
• If you like this video, here's my entire playlist of Excel tutorials: bit.ly/tech4excel
Learn an advanced Excel conditional formatting technique for how to format an entire row based upon the value that's in a specific cell. #excel #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***: www.patreon.com/technologyforteachersandstudents
• Howto & Style

• Tasty Crunchy 2 days ago

Hi all. I m working for medical lab reporting system build in excel. I need to do conditional formatting for a cell containing test value based on following criteria.
Conditions:
1> There is a cell where user enters Gender either Male or Female.
2> Normal range for a Male for a particular lab test is between 10 and 20.
3> Normal range for a Female for a particular lab test is between 15 and 25.
4> Depending on the Gender and related value, the cell value should be formatted.
5> Example 1: if gender is Male and cell value is between 10 and 20, its normal and no formatting else format the test value cell.
6> Example 2: if gender is Female and cell value is between 15 and 25, its normal and no formatting else format test value cell.
I m desperately waiting for helps.

• Cary Ballard 2 months ago

Liked and subscribed. Thanks for the help!

• Bernard Joseph Concha 3 months ago

Thank you so much for all of your videos. They are really helpful. I just want to ask something about whenever I make a formula, Excel won't accept comma as part of it but semicolon instead. I don't know the reason behind this. I am using MS Office 2016.

• nawar naeem 4 months ago

i have an imei about 16 digits and i want to sequence it by sum +1 for example :1236547854123654 so when i sum it with 1 will be like this 1236547854123655 how to do it please??! I tried the normal way but it does not work

• ElvisPresley8Jan1935 4 months ago

Question. What is the formula for this criteria?
Using the if. Example: I want it to highlight the following. If something happens between 16 and 31 days. include the 16 and 31. I can do either but not sure how to do the in between.
Hope you can help.thanks.

• Voice of Overseas 4 months ago

Wahoo great

• Kathy Reese 4 months ago

I do not have this same "New Rule" prompts that your video shows. I am on a Mac. It does not allow me to put in a formula. Any thoughts?

• Kathy Reese 4 months ago

Okay, I figured out how to find this on my Mac, but, it is also highlighting numbers less than in my formula. I used a spreadsheet with items from \$6 to \$26 and typed the formula as =\$c1>20 It highlighted those, but also one at \$6.49.

• Leticia Ramirez 4 months ago

Great, thanks