Google Sheets - Drop Down list to change colour of specified cell

joe123 · 2020-08-26 19:01:45

Hey there, Im just looking for a solution to a relatively easy question I suspect. I have a drop down list with all specified colour coding Eg. "Error" and the cell will change to red. If this drop down list in cell A1 has error selected, I want it to change the colour of the cell A5 also, not affecting A2- A4 (regardless…

26-08-2020 07:01PM

#1

joe123

Registered Users, Registered Users 2 Posts: 6,539 ✭✭✭

Join Date: June 2004

Posts: 6148

Hey there, Im just looking for a solution to a relatively easy question I suspect.

I have a drop down list with all specified colour coding

Eg. "Error" and the cell will change to red.

If this drop down list in cell A1 has error selected, I want it to change the colour of the cell A5 also, not affecting A2- A4 (regardless if anything in that cell is selected or not)

Can anyone explain how I achieve this?

0

Comments

#2 26-08-2020 07:48PM

joe123

Registered Users, Registered Users 2 Posts: 6,539 ✭✭✭

Join Date: June 2004

Posts: 6148

Ah figured it out through conditional formatting and a custom formula

0