Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

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 08:01PM

#1

joe123

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

Join Date: June 2004

Posts: 6146

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 08:48PM

joe123

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

Join Date: June 2004

Posts: 6146

Ah figured it out through conditional formatting and a custom formula

0