countif countifs cell values with colored backgrounds

time：2024-10-14 09:02:37 Smart Hardware

Content 1:

1. Select cell C2 -- click the "Formula" tab in the menu bar -- click "Define Name".

2. Pop up the "New Name" dialog box -- enter "Color" in "Name" -- Enter "=GET" in "Reference Location". CELL(38,Sheet1!$C 2)" -- Click the OK button.

3. Enter "=color" in cell D2 -- you can see that the code of the color value returned by the cell is 3 -- select cell D2 -- move the mouse to fill the D13 cell when "ten" appears in the lower right corner of the cell.

Content 2:

1. Prepare the table to be counted

2. Open the Find & Replace dialog box, click the "Format" button behind the search content, fill in the background color, select the color you want to count, OK, and return to the dialog box.

3. Enter a letter in the "Replace with" box, note that different colors use different letters, and click Replace All. Replace the contents of the other color cell with letters in the same way until all color substitutions are complete.

Content 3:

1. First of all, you need to understand the color properties of the cell: different colors exist in numbers 0 - 55 (bicolor):

2. Create a color name manager - [ Formula ] - [ Name Manager ] - [ New ] , and click [ Close ] when you are done

3. Enter "=Color" in cell A2 and see the free display of the Name Manager:

# Smart Hardware #

《countif countifs cell values with colored backgrounds》 This does not represent the views of this website. If there is any infringement, please contact us to delete it.

Latest article

Recommend

Ranking