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