Advertisement
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
Hi all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back from 1 to 10+ pages to re-sync the thread and this will then show the latest posts. Thanks, Mike.
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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

  • 26-08-2020 8:01pm
    #1
    joe123
    Registered Users, Registered Users 2 Posts: 6,523 ✭✭✭


    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?


Comments

  • #2
    joe123
    Registered Users, Registered Users 2 Posts: 6,523 ✭✭✭joe123


    Ah figured it out through conditional formatting and a custom formula


Advertisement