Hello
I have the below code which moves a row of data to another sheet based on a value selected from a list.
When the list item is selected, I'd like the row to be moved to the "LTS" sheet with all conditional formatting removed. Is this possible?
Private Sub Worksheet_Change(ByVal Target...
Hello,
I'm having trouble with calculating a formula. Refer to the numbers below for the questions.
1. I want to calculate if the PIR price equals the Invoice price to change the PO price to the PIR price.
2. Then if the PIR price and Invoice price don't match up, color code the Invoice with...
Hi all,
A question regarding conditional formatting.
Here is my current situation.
<tbody>
A
B
1
Name
DOB
2
John
01/01/01
3
Jack
02/01/01
4
John
01/01/01
</tbody>
I want it so that when there are 2 of the same names with the same DOB that all of those fields in A will be...
Hi all,
I'm struggling to know the right order to put the conditions in, if anyone could help please.
I would like empty cells to stay blank/white
Any cells with dates in the past or in the next two weeks (i.e past due or due soon) to turn RED
Any dates not due in the next two weeks can stay...
I have a list of first and last names in column A, some first names repeat.
I want to type in a first name in some cell (say H1) and all the cells in the list that have that same first name will be highlighted yellow.
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.