Automatically Change Row Color Based on Cell Input

[exceluser2019]

I am looking for a way to automatically change the color of a row based on the content in a specific cell. For example:

- the default color of any row is white
- if content is added to cell A2, the color changes to red
- if content is added to cell B2, the color changes to green
- if content is added to cell C2, the color changes to white

The cells and the colors are less important than, presumably, the formula needed to create such a functionality.

 

[My Aswer Is This]

I think you will need to use conditional formatting.

We would need a example of what value requires what cell to be colored what color.

 

[exceluser2019]

I am working with sensitive data, so I cannot give exact information. However, the most common color change will happen when a date is entered into a cell. Using my previous example as a reference, the date would be formatted, for example, 15-Jan. When the date is entered within cell A2, the entire row turns red, etc. Please let me know if this does not make sense.

 

[Special-K99]

Create a mockup example, it's not difficult.
Then someone will provide a solution and you can modify it to your actual spreadsheet.

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[My Aswer Is This]

Your original post said:

if content is added to cell A2, the color changes to red
- if content is added to cell B2, the color changes to green
- if content is added to cell C2, the color changes to white

But in your last post you said Entire row color changes.

So you only gave three examples.

What happens if G23 has a value entered what color does that entire row turn

Or H45 or M23
​

 

[exceluser2019]

Thank you all for your feedback. The entire row should change colors, not just the individual cell. Going from left to right, content in a specific cell further to the right within a row would take precedence. So, for example, content in C23 would take precedence over content in A23. Content in another does not affect the color of another row. Therefore, using your example, content in H45 would not affect the color in the preceding or subsequent rows.

I am working right now, but I will do my best to create a little mock up in a few moments.

 

[exceluser2019]

I have a sample file to upload, but I do not have admin rights to install add-ons or programs. Could I simply take screen shots of what I am looking for and then test any formulas that are suggested?

 

[Fluff]

Cross posted https://www.excelforum.com/excel-fo...lly-change-row-color-based-on-cell-input.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[exceluser2019]

https://www.excelforum.com/excel-fo...lly-change-row-color-based-on-cell-input.html

 

[exceluser2019]

I cannot post a link in the other site.

While I understand the restrictions, I was asked to provide a sample file, but I cannot do that because of the lack of admin privileges I have. Can I simply show screen shots via imgur?