Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have created an action item task list. Column C has drop down lists which say complete, pending, and in progress with corresponding color coding. The column next to it is the due date and I would like to get that column to change color as you change the progress status on the left simultaneously.
Solved by E. Y. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 09/10/2018 - 02:37
Good Morning
User 09/10/2018 - 02:38
good morning
Excelchat Expert 09/10/2018 - 02:38
I welcome you on Excel Chat
User 09/10/2018 - 02:38
Thank you.
Excelchat Expert 09/10/2018 - 02:38
Also wanted to ensure you for the solution of your problem. So I read that you want to apply the same color coding of your status to other column as well?
Excelchat Expert 09/10/2018 - 02:38
Am I right?
User 09/10/2018 - 02:39
Yes
Excelchat Expert 09/10/2018 - 02:39
Okay. This is very easy. Can I have your spreadsheet please?
Excelchat Expert 09/10/2018 - 02:40
I ensure you for the data privacy and will not change any formatting
Excelchat Expert 09/10/2018 - 02:40
Are you using Google Spreadsheet or Excel File?
User 09/10/2018 - 02:40
Okay thank you.
[Uploaded an Excel file]
User 09/10/2018 - 02:40
Excel
Excelchat Expert 09/10/2018 - 02:40
Yes, I received it and opening the file
User 09/10/2018 - 02:41
Thank you.
Excelchat Expert 09/10/2018 - 02:41
Please allow me few seconds to check it
User 09/10/2018 - 02:41
OK
Excelchat Expert 09/10/2018 - 02:41
So you want me to apply the same conditional formatting to Column D as well
User 09/10/2018 - 02:42
I want column D to change color when you change that status on column C
User 09/10/2018 - 02:42
the corresponding color
Excelchat Expert 09/10/2018 - 02:42
Sure
Excelchat Expert 09/10/2018 - 02:42
Please give mew few minutes to apply the settings
User 09/10/2018 - 02:42
Thank you.
Excelchat Expert 09/10/2018 - 02:47
So here you go
[Uploaded an Excel file]
Excelchat Expert 09/10/2018 - 02:47
Please open the file and check, if it solves your problem
Excelchat Expert 09/10/2018 - 02:48
I just changed the conditional formatting criteria and range to Column C and D. So if Column C contains the listed values i.e. Complete, Pending, past due, the color coding will apply to both the columns
Excelchat Expert 09/10/2018 - 02:48
Please use the same and advise, if there is still any challenge with the problem or solution
User 09/10/2018 - 02:48
But column d does not contain the same information
Excelchat Expert 09/10/2018 - 02:49
It is using the Column C information to change the color
Excelchat Expert 09/10/2018 - 02:49
So once you click the conditional formatting, you edit the rule. You will see the criteria what I used
User 09/10/2018 - 02:50
THANK YOUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUUU
Excelchat Expert 09/10/2018 - 02:50
My pleasure
Excelchat Expert 09/10/2018 - 02:51
Thank you for contacting Excel Chat today and look forward to see you back on Excel Chat
Excelchat Expert 09/10/2018 - 02:51
Have a great day
User 09/10/2018 - 02:51
You toooo
Excelchat Expert 09/10/2018 - 02:53
Could you please end the session?

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.