Colour changing in rows determined by text in 2 different cells

Question

Colour changing in rows determined by text in 2 different cells

Solved/Closed

Report

kitchens - Mar 17, 2016 at 12:01 PM
TrowaD

Posts: 2829
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: November 22, 2021

- Mar 17, 2016 at 12:19 PM

Hello, i would like to change the colour of a number of cells in a row if column P contains any text, however the colour it changes to depends on the text in column D would you please be able to help

many thanks.

Colour changing in rows determined by text in 2 different cells
How to change a row color based on a text value in a cell - How-To - Excel
Change colour of range of cells based upon text from a drop down menu in another ✓ - Forum - Excel
Grey out an entire row in Excel 2010 depending on a cell's value ✓ - Forum - Excel
Macro to add/remove rows based on highest # in group of cells ✓ - Forum - Excel
Copy rows to another sheet based on specific cell value in microsoft excel ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Accepted Answer · 2016-03-17T12:19:10-0400

Answer 1 / 1

TrowaD

Posts: 2829
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: November 22, 2021

490
Mar 17, 2016 at 12:19 PM

Hi Kitchens,

Try these formula's:
=AND($P1<>"",$D1="Green")
=AND($P1<>"",$D1="Red")

As shown in the pic below:

Best regards,
Trowa

Colour changing in rows determined by text in 2 different cells

1 reply

Your reply

Subscribe To Our Newsletter!