Colour changing in rows determined by text in 2 different cells [Solved/Closed]

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: 2727
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: April 20, 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
Task bar colour change - How-To - Windows 7
How to change a row color based on a text value in a cell - How-To - Excel
Excel VBA - Change cell color based on value ✓ - Forum - Programming
Copy rows to another sheet based on specific cell value in microsoft excel ✓ - Forum - Excel
Grey out an entire row in Excel 2010 depending on a cell's value ✓ - Forum - Excel

1 reply

Ask a question

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

Answer 1 / 1

TrowaD

Posts: 2727
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: April 20, 2021

459
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 [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!