Format data based on cell color fill

PetrusV

New Member
Joined
May 12, 2022
Messages
16
Office Version
  1. 2021
Platform
  1. Windows
I have data that looks like this:
Book1.xlsx
A
1 ENVELOPE
2Message:- An envelope means that you will receive a message. The message is not known yet (timing not right) as the envelope is still closed. The colour of the envelope can give you an indication who the message is from.
3- Yellow envelope
4Contention:- A dark or mustard yellow envelope can point to a message
5filled with anger, contention, resentment and jealousy.
6Love:- A soft-yellow envelope can point to passion, love, purity and the glory of God.
7 ESCALATOR [elevator]
8- Ascending escalator
9Spiritual promotion:- If you are ascending or moving up the escalator it shows that the Lord is promoting you to higher levels of spiritual maturity in the spiritual realm [gifts of the Holy Spirit]. You will move without any effort from yourself (2 King 2:14, 1 Peter 2:5, Gen 28:12).
10- Descending escalator
11Spiritual demotion:- Can be a warning that you are moving to lower spiritual levels [legalism, traditionalism]. It is a caution for you to spend more time with the Lord to maintain your level of spiritual maturity (1 Sam 13:11).
12 EVERGREEN
13Permanence:- A symbol of permanence which can show a righteous person who will inherit eternal life (Is 1:1-3, Is 6:13). It can also be a promise of the prosperity of the children of God (Is 65:22).
Sheet1


I need it to look like this:
Book1.xlsx
AB
1 ENVELOPEMessage:- An envelope means that you will receive a message. The message is not known yet (timing not right) as the envelope is still closed. The colour of the envelope can give you an indication who the message is from. - Yellow envelope Contention:- A dark or mustard yellow envelope can point to a message filled with anger, contention, resentment and jealousy. Love:- A soft-yellow envelope can point to passion, love, purity and the glory of God.
2 ESCALATOR [elevator]- Ascending escalator Spiritual promotion:- If you are ascending or moving up the escalator it shows that the Lord is promoting you to higher levels of spiritual maturity in the spiritual realm [gifts of the Holy Spirit]. You will move without any effort from yourself (2 King 2:14, 1 Peter 2:5, Gen 28:12). - Descending escalator Spiritual demotion:- Can be a warning that you are moving to lower spiritual levels [legalism, traditionalism]. It is a caution for you to spend more time with the Lord to maintain your level of spiritual maturity (1 Sam 13:11).
3 EVERGREENPermanence:- A symbol of permanence which can show a righteous person who will inherit eternal life (Is 1:1-3, Is 6:13). It can also be a promise of the prosperity of the children of God (Is 65:22).
Sheet2


Any help would be greatly appreciated!!

(The data on the left will always be filled with grey color. The data on the right must always be added inside the single cell of the name on the left.)
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Forum statistics

Threads
1,213,532
Messages
6,114,177
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top