-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
colour adding
-
L
VBA alternative to conditional formatting
Hi all. I am working on a large data entry and reporting system in excel. Currently the area of drop down boxes covers 1.3 million cells and will probably end up double that. I was using excels inbuilt conditional formatting to grey out box's that are contain an "X" to improve the user...- LORDMARKS
- Thread
- Replies: 1
- Forum: Excel Questions
-
T
Colour shapes when certain criteria is met on different excel tab
Hello, I'm working on an excel and have two tabs: Tab 1: in tab one I've added a picture (total ownership with all differtent owners of a plot of land) and on top of this picture i've drawn freeform (shapes) corresponding with the different ownership positions on this entire plot (let's say...- Twan1980
- Thread
- Replies: 1
- Forum: Excel Questions
-
M
Change pattern colour linked to content
Not sure if someone has asked this before, if so I can not find it. I have a sheet that needs to be formatted for printing. The text in the file is a lookup form a different sheet. What I am trying to do is colour code thing ie if the cell is YEL and change colour to Yellow, BLU to Black and...- Matthew
- Thread
- Replies: 4
- Forum: Excel Questions
-
J
Add together Values in Coloured Cells
Hi, I have had a look through some searches and I can't find any that have answered this question before so would appreciate it if someone could assist. I have a few cells on a sheet which will be coloured red. They won't always be the same cell references, but they will always be the same...- jamieleeuk
- Thread
- Replies: 3
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
change colour of picture based on cell value
- Replies: 46
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am... -
VBA - Combine Multiple workbooks into 1 worksheet
- Replies: 45
Hi, I am trying to write a VBA script which will combine multiple workbooks into 1 worksheet, copy and pasting all columns as values. Each sheet... -
Last Display on userform to a Listbox
- Replies: 35
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am... -
Vlookup and hlookup combination
- Replies: 28
Hello forum friends, I am using Excel 2016, XLOOKUP is not an option for me (I think). I have a worksheet that is linked to a website where the... -
Code giving run-time error when called, but not when placed on worksheet.
- Replies: 23
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when... -
Help with Current and highest streaks
- Replies: 23
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...