I have "SalesTable" and If I select March 1st 2017 to March 15th 2017, it has to calculate immediate 15 days before data and show the % change. or If a user select 10 days of data it has to compare the immediate 10 days previous data and show the % change.
I have problem with this formula:
Sub Cell_color()Dim MyWorkbook As Workbook
Dim Matrix As Worksheet
Dim Help As Worksheet
Dim Data As Worksheet
Set MyWorkbook = ActiveWorkbook
Set Matrix = MyWorkbook.Sheets("Matrix")
Set Data = MyWorkbook.Sheets("Data")
Set Help =...
Hoping someone can help me with this one. I've tried the COUNTIF and the IF methods I could think of and I can't figure how to make a simple formula I can put into the cells of a column that will do the following:
Consider that Column E needs to contain a list of dates.
1. I need a formula...
Okay, don't know if that Title will do it. However hopefully someone can help me with the following. I think it is conditional formatting that I want to use, but it doesn't seem to be quite right.
I have a row of numbers and I want to have the system notify me or colour the cell or in some way...