Hello All,
How do I change the color of a cell, based on a drop-down list option on another sheet?
Sheet A Cell B23 - User selects "No".
Sheet B Cell A35 should change to red.
Thanks,
Chris - Excel Newbie
Hello All,
How do I change the color of a cell, based on a drop-down list option on another sheet?
Sheet A Cell B23 - User selects "No".
Sheet B Cell A35 should change to red.
Thanks,
Chris - Excel Newbie
you can use conditional formatting
select cell SheetB!A35
then create a cond format formula
=SheetA!B23 = "No"
set fill to red
However see yellow banner at top of screen and attach a sample spreadsheet
Last edited by etaf; 01-11-2022 at 04:18 PM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Select Sheet B cell A35 and use Conditional Formatting with the CF formula =SheetA!$B$23="No"
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you very much!
Have a good one.
you are welcome
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks