colour coding

  1. C

    Getting freeform shapes to change colour corresponding to values in cells

    Complicated one which is why I am struggling and cant seem to get other suggesstions on this topic to work. Situation I have a map of the UK split into 36 zones displayed by 36 freeform shapes on my worksheet. I have a list of 14 teams in a table next to the image to which the zones will be...
  2. U

    Tickbox and highlight cells

    Hi, I'm trying to create an excel sheet where if I check the tick box to show it's been paid, it would highlight all the cells in the row once ticked; so once that box is checked, everything turns red rather than having to select all the cells and change the colour manually. Many thanks in...
  3. B

    comboBox colour change depending on selection

    I am using excel 2007 and i want to change the background colour of a combBox(Active control) depending on what is selected. So I have a simple Yes/No selection that is blank to start off with. When it is blank i want the colour to be default, but when you choose Yes i want the backgroung to...
  4. L

    Background colour of drop down list.

    I have several drop down lists on an excel 2007 worksheet. Is there any way to set the background colour of the box so it is not black text on white background, but black text on for example a grey background? The colours do not need to change, just be set once on this particular sheet. Any...
  5. F

    Colour Coding

    Hi I have a list of 20 items in a table with codes, configurations, pallet types and lane capacity, i'm using the vlookup formula to insert the codes etc. when i select the items. However i would like to have the items colour coded automatically when i select them. How do i do this?
    • fiaz
    • Thread
    • cell background colour coding vlookup
    • Replies: 2
    • Forum: Excel Questions

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
Back
Top