Advanced Conditional Formatting - Google Sheets - Use Formulas, Cell References

Learn how to apply advanced conditional formatting in Google Sheets using formulas. We'll create logical test formulas to apply conditional formatting, sample cases with cell references, highlighting the entire row, references to other worksheets, highlighting duplicates & extra duplicates, highlighting rows that appear on a list in a different worksheet. and more.

INDIRECT

IF, IFS

IF, AND, OR

#googlesheets #conditionalformatting #advanced

[OscarRivas_onexatimer]

There's nothing better than this videos. No one can explain better. Direct and to the bone. Excellent!!!

[JohnBGood]

Amazing lessons! Thank you!

Just one hint I give you, if you let me do so: in the conditional formatting rule box, you can use the "Apply to range" to set the range you want the rules to apply.
So, no need to delete the entire rule and start setting it all over.
And, when you start setting a rule OR you are about to modify one, you just need to have one cell selected, at least. The conditional formatting rule box will show the entire range to which that rule is applied (even if you selected one cell or a part of the data range) .
I think it helps a lot when modifying existing rules.

[rion]

I watched this a year ago as I was getting into writing formulas and using Conditional Formatting and loved it, but only half understood the logic. Now, a year wiser with a lot of experience messing with spreadsheets and personal projects, I came back to this again to get the formula and it's like a lightbulb went off. Everything just clicks now. Best feeling. Truly, your channel is just the best thing, just thank you so much for all your hard work! :D

[tedbrunt]

I can't thank you enough for this - I have been looking for an answer for days for this and it worked perfectly. Cheers!

[novac]

Thank you! I'm used to the conditional formatting in Excel. Now I'm learning how to use Google sheets. So of course when I got to the point that I needed use Conditional Formatting, I was just putting in formulas like "=F13" (My reference cell) and getting illogical results. Now I understand how it works for Google Sheets. The formulas need to be Boolean! Thank you!

[michaelmarroquin.]

A million thank yous. I have over 400 names I need to have highlighted on my spreadsheet that from the beginning of the year, and bam just like that, they were all highlighted.

[pPOS]

You have been a great mentor, I want to highlight a word in a column or row particularly, it shouldn't highlight the entire row or column!

[Soundofegypt]

You fix many of my work with simple steps. thank you for your great work

[thomastorodo]

Thank you very much ! I was getting headaches from trying to use formulas for conditionnal formatting, I still have headaches but now I know why.

[robertmaluka]

I was doing it different to get my results. But yours is a lot shorter and easier. Great video

[doctorkankle]

Man this is EXACTLY what i was looking for thanks SO MUCH!!

[MichaelDaniels]

I would love to see a lesson on creating a conditional format using Script. For example, Adding a a border to every row where the date changes. Thank you for your awesome videos

[SolidSnake]

Funny that the best video about Conditional Formatting on YT I found so far is not made in Excel.

[leekspinner]

thank you!
i'm new to Google Sheets and Excel and I'm surprised highlighting the second occurrence of repetition is only a matter of locking the components

[luiscorado]

You are part of the USA treasure my friend. Thanks for all you do

[davidtopp]

Your videos are wonderful, and have helped me very much. I have built a Google Sheets check register and budget, but I have a question concerning "Conditional Formatting". I have added several conditional formats to my check register, but there is 1 that I cannot figure how to construct. First, I have built my register a little different using "1 column" that contains Withdrawals, Deposits, Transfers In, Transfers Out, & Credit Card Refunds. I have set up conditional formatting to set font color, and cell fill for each of these items. Here is what I would like to do: When I enter a number that is a "Withdrawal" or "Transfer Out", I would like the number to "automatically turn negative". I already have the negative numbers turning red, but would like the additional feature if possible. If you need it, I could email you a partial section of the file with fictitious figures. Thank you again!!

[FlorisMevissen]

Awesome video! Is there a way to highlight cells when your table is focussed on cells within rows instead of entire rows based on their value in a particular column? To clarify, I have a monthly timeline going from left to right and there's a benchmark number in de rows that keeps on getting back (every month) that I'd like to give a transparent look as long as the month-values aren't filled in yet. (Hope that makes sense 😬)

[boytapangbabyvlog]

amazing! thanks for this a great lesson, many times I tried but I always failed but now I know, it so very big help to me...

[OneWayTransitManagementTeam]

Great video . What if I want to do an if the value is <a number change another cell to a certain number.

[andywang]

GENIUS!!! Thank you for amazing and practical tutorials. You are super PRO!!!