Conditional Formatting Formulas - Mystery Solved with 3 Simple Rules

Conditional Formatting with formulas in Excel can be frustrating, but in this video I uncover how Excel works under the hood and give you 3 simple rules to make writing formulas for conditional formatting foolproof.

[anitafloryanska]

i had been trying to find the right formula for conditional formatting in a gantt project management spreadsheet all day on friday. 2.51 minutes of your video and I did it.... thank you

[sourabhsharma]

Everytime you upload a video, that makes my work more easy and I lean a new interested thing everytime.
Thank you, I literally love this channel more than any other.

[julianzacconievas]

Absolutely, this video is being bookmarked. Every time I need to do this I have to re-learn it, this will fix that. Thank you!

[rmancuso]

I never really understood conditional formatting with formulas, and consequently found it frustrating and iterative. This video makes it so clear! Thank you for sharing it.

[jimfitch]

I’m a CF fanatic & use it on almost every spreadsheet. 95+% are formula-based. Love that flexibility. But, oh, it was a painful learning curve (3-4 years ago). Hair-pulling is an apt description (except that my hair loss is mostly natural). Great lesson on a very useful feature!

[IvanCortinas_ES]

The picture Excel is key for understanding the meaning of conditional formatting! Thank you for your explanation Mynda.

[chiwilanjabulosikwila]

Thanks for this Mynda!! Can’t believe you were able to explain this so succinctly in just over 4 mins. You have cleared up A LOT of confusion I had as to how exactly this conditional formatting works. I will from now on always apply these 3 simple rules. It’s goodbye to the guesswork😁😁. Thanks again!

[anastasiostresinis]

Brief and at the same time to the point, explanative and precise! Your knowledge and command of excel is admirable! Thank you dearly, for sharing it with us dummies!

[menglandau]

A great explanation of something so simple but yet I always struggle with. Thank you

[seanlee]

Your lesson is incredibly amazing! Thank you so much for this video.

[davegoodo]

Thanks Mynda, you are truly one of the few "Fair Dinkum" Excel sites with down to earth teachings IMHO.

[bccabernet]

Mynda, this is fantastic! I created a spreadsheet for when my medicines are due to be refilled... and it's set up almost similar as your book due spreadsheet. This conditional formatting would help me to visually see which meds are running out first. TY and I made sure to share your video!

[oco]

That clip where you pasted what each cell sees when running a conditional format helped so much. I was spinning my wheels trying to get my format to work, thanks alot

[jamie]

the best proper advice on CF, thank you. It will help me a lot.

[hcandts]

Thanks Mynda, as always, you hit the nail on the head

[farzanmoha]

I appreciate it very very much Mynda, you opened my eyes for ever. Was such a pain that why always I forget what to do.

[DougHExcel]

An unconditionally wonderful explanation of conditional formatting...thanks!

[tcgtmgf]

Excellent! Cutting and pasting the formula was what I needed to know - trying to get the format right has been driving me mad! Thank you very much for your very clear and concise video.

[MrSweck]

I had practically given up on formula based conditional formatting. Just too much hassle and didn't make it work half of the time. But a year ago I read about that TRUE/FALSE-way in the sheet and it became simpelt over night. Now I'll rather say I'm over using it. It's just not a "formula friendly enviroment" inside that little box that seems to enter what it wants and all in black characters. So I'm with you. Construct in the SHEET and make the formatting work on the first try.

[grwhorca]

2:31 ❤ the way you articulated Excel and Your thought process, "Excel"lent. Love your work🙏