Excel IF Function Based On Cell Color - Compare Cells based on color
In this tutorial, I'll show you how to use an IF formula based on cell color.
⬇️ https://exceldashboardschool.com/if-s...
The COLORMATCH function compares two cell colors. In the first example, I want to increase the price by 25% if the cell color is green. If the cell color is not green, we keep the price untouched.
The function returns boolean values: TRUE if a match occurs and FALSE if different colors occur.
Chapters:
00:00 Intro
00:05 The COLORMATCH Function
00:35 How to use the IF statement based on colors
01:32 Multiple conditions - Nested IF statement based on colors
🎓 LEARN MORE in my Excel tutorials: https://excelkid.com/
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
🎁 SHARE this video and spread the Excel love.
If you are in a hurry, please click the 👍
#excel #exceltips #exceltutorial #excelformula
