colour change

Hi, I have a worksheet with a few columns and rows. INPUT TABLE Group name Wk 1 Wk 2 Wk 3 Wk 4 Group 1 red red Group 2 yellow yellow Group 3 red purple Every week we review the performance of the different groups and colour the inside of the cell in certain colour...

Hello I have a time consuming problem. I make a lot of risk analyzes and depending on the probability and the consequence the risk is marked with Green, Yellow or Red. Now I change the colour manually but it would save a lot of time if the cell changed colour depending on the values in the...

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...

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...

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...

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...

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...

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...

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...