Highlight a cell based on the selection of another cell

Mrs. T

Board Regular
Joined
May 24, 2007
Messages
105
Office Version
  1. 365
Platform
  1. MacOS
I'm trying to get one cell to highlight based on which selection from the validation table is selected in another cell.

In Cell A1, I have "Choose One" to populate based on another cell.
In Cell B1, I have a validation table with Yes or No as the selections to choose from.

I want Cell B1 to highlight if A1 says "Choose One"...so other users know where to choose an answer.

Thanks!
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

mrbeanyuk

Board Regular
Joined
Nov 30, 2005
Messages
212
Hello there

Using conditional formatting in column B, condition one to be:

Formula is =IF(A1="Chosen One", TRUE)

Then choose the highlighting colour

Hope this helps
 

Lewiy

Well-known Member
Joined
Jan 5, 2007
Messages
4,284
Select cell B1.
Format>ConditionalFormatting>Formula Is:
=$A1="Choose One"

Choose the background colour you want, click OK.

You can now PasteSpecial>Formats down the column if you wish to use it for other cells as well.
 

Mrs. T

Board Regular
Joined
May 24, 2007
Messages
105
Office Version
  1. 365
Platform
  1. MacOS
How simple that was! That worked, thank you! :biggrin:
 

Forum statistics

Threads
1,181,418
Messages
5,929,793
Members
436,694
Latest member
dpatete

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top