Excel conditional formatting based on another cell value

The video shows how to use conditional formatting in Excel to highlight entire rows based on another cell value. For more examples of Excel conditional formatting formulas, please see:

[justincase]

You are a legend! I was missing that dollar sign everytime - and that drove me nuts!

[mariameade]

Hello, In exactly one minute and 56 seconds into your video you solved my issue. Thank you so much for making this. It's concise and to the point. I can't wait to watch the rest and maybe learn some more stuff I didn't know. I use excel in my job a lot and the formulas and highlighting certain cells, pivot tables etc. are a bit part of my job. Great video I just had to let you know :-)

[normaburke]

Thank you!! I was having issues and couldn't figure it out on my own. You have truly saved me hours of work.

[TheMishmak]

Thank you so much. This saved me looking for my common genes (from 4 different treatments) in almost 45, 000 rows of RNA Sequencing data. You are God-sent.

Thank you. I was lost in google sheets, but now I understand everything i need to make full line colored based on one cell in that line <3 Thanks

[suzanneanelli]

Hi. I would like to set a formula to highlight a range of cells that fall below 50% of a different cell. Please help.

[dmhergott]

I have different conditional formats to each cell in a column. When I sort the data don't follow the cell. How can I get them to follow? Thanks

[Watchthespin_]

Nice video. I have two columns of item prices. The prices don't need to be an exact match, but I want to format values in column 2 when they are not equal to a value that is plus or minus a few dollars from the price in column 1. Any suggestions on how to do this would be greatly appreciated.

[tastycrunchy]

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.

[rjlaxm]

I need to do the following:
If a cell contains "ErrorMessage" then go up in the column until the cell containing "RepresentationInformation" is found and highlight that cell in yellow. Thanks

[raghuprabhu]

I have three columns and I want to format.


If the InvDue is past and not paid color the row red, if the InvDue is in the future and not paid color the row green else color the row green


How do I do a conditional format for this problem??


Thanks
CustID InvDue InvPaid
123 15-Sep-19 15-Sep19
this row green
124 23-OCT19
this row red
125 20-Nov-19
this row blue

[joshuamclean]

Thanks for this - how do I complete this for a list of cells that I want to be greater or less than and then copy this conditional formatting. Eg sales from 2017 are greater / less than 2018 for different rows of sales reps. Your help is appreciated

[regaljohnston]

i have a database of clients, deposits and interest growth in a private spreadsheet... is there any way to create a seperate PUBLIC sheet where clients can input their personal USERNAME and PASSWORD to populate cells with values from the private sheet?

it's for a game i play online called TORN... i set up a bank in the game and it's become hugely successful, just wanna give clients the ability to track their deposits and interest growth. any help would be hugely appreciated.

[omairbinenam]

1:40 What if the blank cell has a formula in it?