Excel formula to get cell color

0 votes
If there is an inline formula that can be used to determine the colour of the cell, that would be great (without using any macros)

Home User Office package 2010 is what I'm using.
Oct 23, 2022 in Others by Kithuzzz
• 28,700 points
911 views

1 answer to this question.

0 votes

Add a Name(any valid name) in Excel's Name Manager under the Formula tab in the Ribbon.
Then assign a formula using GET.CELL function.

=GET.CELL(63,INDIRECT("rc",FALSE))

63 stands for black color.
Let's say we name it Background so in any cell with color type:

=Background

Result:
enter image description here

answered Oct 23, 2022 by narikkadan
• 53,160 points

Related Questions In Others

0 votes
0 answers

What is the formula to keep first two words in a cell over excel?

I want to maintain the first two ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
• 28,700 points
63 views
0 votes
1 answer

Formula to remove every middle name in a cell in Excel

Use this: =IFERROR(LEFT(A1,FIND(" ",A1)-1),A1) What does it do? Finds the ...READ MORE

answered Jan 19 in Others by narikkadan
• 53,160 points
35 views
0 votes
1 answer

Excel VBA - Need to get a specific line from TextBox and send to an specific Cell

Moving your string into an array first ...READ MORE

answered 4 days ago in Others by narikkadan
• 53,160 points
27 views
0 votes
1 answer

Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 22,940 points
680 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 53,160 points
1,142 views
0 votes
1 answer

How to categorize/classify numbers from different ranges using Excel?

I wouldn't advise utilizing nested IFs because ...READ MORE

answered Oct 28, 2022 in Others by narikkadan
• 53,160 points
336 views
0 votes
1 answer

How do I specify a variable Excel range?

Try this: =SUM(OFFSET(A1,0,1,1,3)) To break it down: OFFSET(reference cell, ...READ MORE

answered Oct 30, 2022 in Others by narikkadan
• 53,160 points
83 views
0 votes
1 answer

Excel shared formula expansion

You can use Linq I would start ...READ MORE

answered Nov 7, 2022 in Others by narikkadan
• 53,160 points
89 views
0 votes
1 answer

Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

answered Jan 9 in Others by narikkadan
• 53,160 points
40 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP