colour change

  1. R

    CHANGE CELL COLOUR WHEN CELL NOT DOUBLE CLICKED

    good morning everyone, I'm hoping that you will be able to assist me Within my spreadsheet i have a column titled expected delivery date (starting in cell b5), in another column i have a vba code which allows me to double click that cell (starting in J5) and the entire row will disappear, what...
  2. B

    Changing data bar colour based on value?

    Is there a way that you can conditionally format a data bar to a different colour, depending on value? So if it was '0-34%' it would be red, '35-75%' it would be amber etc. ? I don't want to make a bar graph as this information is in a table. I have seen a few instructions on how to do this...
  3. E

    Create dropdown menu with text in background

    Hello, I've been searching the internet for a solution, but not sure one exists: I want to create a dropdown menu which allows the user to select 'red', 'amber', and 'green' and changes the colour of that cell as appropriate. This part I have achieved successfully. However I would now also...
  4. M

    Conditional Formatting - Arrow Colour

    Hi - hopefully some one can help me !!! Is there any way when doing conditional formatting that you can change the colour of the arrows ? So say when comparing overheads from budget to actual - if the overheads have gone down thats good !!! But when using the arrows on CF it appears Red ... and...
  5. J

    VBA/ Macros Conditional formatting Bar graph

    Im wondering if anyone can help me im looking to make a large number of histograms change colour depending on the bar value. If the value is below 0 (<0) I need the bar to be green RBG (0,255,0) if the value is above 0 (>0) i need the bar to change red RBG (255,0,0) Does anyone have any ideas...
  6. J

    IF & VLOOKUP with multiple criteria

    I am trying to create a customer-based sales tool for my brewery business. I purchase different beers and sell them with 2 options, 'an offer' price and a 'floor' price. On my Sales worksheet, I have a list of products, using validation (which are positioned in a 3-column table, combined...
  7. B

    Change auto shape colour on cell value

    Hi all, I was wondering if you can help. I have created a strain gauge bridge calculator. The bridge has 4 resistors, I have also added a picture of the bridge using autoshapes and have 4 rectangles to represent each resistor (rectangle1,rectangle2,rectangle3,rectangle4). I want to add a...

Watch MrExcel Video

This Week's Hot Topics

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