If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

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…

Options

26-08-2020 8:01pm

#1

joe123

Registered Users Posts: 6,521 ✭✭✭

Join Date: June 2004

Posts: 6130

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

Options
#2 26-08-2020 8:48pm
joe123

Registered Users Posts: 6,521 ✭✭✭

Join Date: June 2004

Posts: 6130

Ah figured it out through conditional formatting and a custom formula

0