Hi, I'm new to this forum as poster. In the past I was able to use the tips and solutions given here. Thank you for that!
Now I have an issue where I could not yet find the answer.
I have a sheet which needs conditional formatting. I want to do this with a table where I define all elements...
@ How to change "H2" cell color change After "FALSE" ????????????????????????????????????????????????????????????????????????????????????? (No VBA only for condition formatting)
I need help figuring out a formula that will allow me to count the number of unique occurrences for a list of values that show up within specific categories.
Basically, I have data like this:
A
B
1
Booking Type
Room Number
2
Office Hours
123
3
Office Hours
125
4
Event
200...
I have a drop down list with 4 options - A, B, C, and D. I need that only when C is selected from the list, the cell itself has a hyperlink. So, if cell B4 gets the value C from the drop down list, then C or the cell itself should be hyperlinked to say Google.com. If any other value is selected...
Hello all. Looking for help. Have a column of units representing weight. Wanting to easily create a new column to represent shipping weight.
Would like to know a good formula for adding 50 pounds to any number in the column over its original 100 pounds.
Best way to proceed would be? Will...
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.