format cell colour

  1. V

    Highlight Selected Cells

    I am trying to create a macro that will highlight cells already selected. Below is the code I used but that is only working for the active cell. How can I alter the code to highlight all the cells I selected. Example: Cell C15 is the active cell and cells C15:C20 are selected. When I run my...
  2. V

    Conditional Formatting

    Hello, I want to conditionally format columns based on quartiles. I am able to conditionally format single column at a time but I have more than 100 columns to format. It's time consuming to edit cell values for each column. So how I can put condition in conditional formatting which is...
  3. J

    Using Graded Color Scale Conditional formatting for cells surrounding the value itself

    Hi I am an analyst/accountant for a UK retailer. What I have is a set of variances to forecast which I have developed into a variance "wall". Each brick in the wall has the title of the area it represents as well as: Actuals Budget Variance I like to use the conditional formatting graded...
  4. B

    Help highlighting adjacent cell ten business days (exclude holidays) after the date found in the cell beside it

    Hello, I have been trying to work on this with conditional formatting for a couple of days now to no avail :( Here is a photo of the chart I'm working with: I have made it so that every time a "FILE NUMBER" is entered the cell to the right in grey shows the date it was entered in dd-Mmm-yy...
  5. A

    Formatting based on comparison with other cells

    I am a teacher and am tracking grades my students get on a series of four tests. I want to format the cells so that if their scores go up from one test to another then the cells turn green, if they stay the same they turn yellow, or if they decrease they turn red. I've tried multiple ways (IF...
  6. T

    Formatting problems

    I have tried to format a set of data with the following rules: =AND(OR(P2="AIR";P2="SEA");W2="";M2<(TODAY()+7)) If I put it in as a normal formula, the outcome is correct. However, if I put the same formula in as a format (to color the ones that are TRUE) it will only apply to some of the cells...
  7. C

    How to set the cell colour by using cell values for Hue and Saturation values

    Hi, I hope somebody might be able to give me some tips / proper help on how to set the cell colour by using cell values for hue, saturation and brightness. Essentially I am trying to find a way to make colour charts to use when paint matching in object conservation (think really finely...

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