How to auto fill text based on cell colors in Excel?

In this video, we are going to show, how to auto fill text based on cell colors in Excel?

Suppose, there is a list of cells filled with background color red or green, now you want to fill texts based on the cell filled color.

Formula is : =IF(GET.CELL(38,Sheet1!A1)=10,"No",IF(GET.CELL(38,Sheet1!A1)=3,"Yes","Neither"))

➤ Most Important note is that, Sheet1!A1 indicates the cell A1 in the sheet named formula, 10 and 3 is the color index, you can change them as you need.

PRODUCTS :
___________________________________

1. Kutools for Excel : It is a powerful toolbox that frees you from performing time-consuming operations. The toolbox has more than 300 powerful functions for Excel. Kutools for Excel is an incredible handy Microsoft Excel add-ins collection to bring advanced functions and then free you from time-consuming operations.

2. Kutools for Outlook : Brings multiple powerful features to Microsoft Office Outlook 2010 -2021 and Office 365.

3. Kutools for Word : It is a powerful software that frees you from time-consuming operations which majority of Word users have to perform daily! It contains 100+ powerful functions and tools for saving hours of your time in Word.

4. Office Tab : It brings the tabbed user interface to Microsoft Office 2003, 2007, 2010, 2013, 2016, 2019, 2021 and Office 365 (include Word, Excel and PowerPoint). It gives users the ability to open, read, edit and manage multiple Office documents in the same tabbed window. Easy to deploy in your Enterprise or Organization. Supports all languages that are supported by Microsoft Office.

5. Office Tab + Kutools for Excel / Outlook / Word : Bundle package of Office Tab, Kutools for Excel / Outlook / Word.

6. Office Tab Enterprise : Office Tab brings the tabbed user interface to Microsoft Office 2003, 2007, 2010, 2013, 2016, 2019, 2021 and Office 365 (include Word, Excel, PowerPoint, Publisher, Access, Project and Visio). It gives users the ability to open, read, edit and manage multiple Office documents in the same tabbed window. Easy to deploy in your Enterprise or Organization. Supports all languages that are supported by Microsoft Office.

#excelvba
#excelapp
#excelcalculator
#excelentertainment
#excelinterviewquestions
#excelinterview
#excelmacro
#excelshorts
#excelvbaforbeginners
#excelvbatutorial
#excelvbacode

[RomeuMiguel]

The question is, I have a range of 100x100 with 20 colors on that, it is pixel art, is it possible for that function auto-identify and put a number?

[sdhnez]

Can you auto fil numbers in multiple cells? (route#/day#/stop#)

[adhikaa]

It says get.cell function is not valid in my excel spreadsheet. How to solve it?

[vinnydeathgrinder]

Hlo, thanks for video
How to do this for colors in 2 cells. For eg. If cell1=yellow and cell2=green then cell3="miss"

[eat.nwatch]

Hello, thank you for the support, but it doesn't work, it returnes for me #Value!

[socoreflexology]

NO matter what cells I use cannot get this to work. Immediately upon hitting "Enter" it opens the "Open File" window.

[vinnydeathgrinder]

Doesnt work. It says 'you have entered too many arguments