How to use Cells Colors as a Criteria in Excel | IF function Based on Cell Color | 2 Methods

In this Excel video tutorial, we will learn how to use colors as a criteria with the if function. How to use cells color as a criteria of the if formula. How to count cells colors.

How to Count Cell Colors:    • How to Count Cell Colors in Excel wit...  

If you have a table, a spreadsheet, where you colored your cells, you can return the colors code with this formula that I'm going to show you.

To create this function in Excel, we will use Excel's Visual Basic Application, VBA.

1st CODE:
Function cordacélula(célula As Range) As Long
cordacélula = célula.Interior.ColorIndex
End Function

2nd CODE:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.CalculateFull
End Sub

The IF function in Excel is a powerful logical function that allows you to make decisions in your formulas based on specific conditions. Nested IFs is when we use a function with a function or a formula inside a formula in Excel. With the IF function, we have what is called, nested formula. It can handling multiple conditions.

#JopaExcel #Howto #Excel