In VB editor Window Double click the Sheet where you are getting Coin Market Updates & Paste this VB script.
I'm assuming that in Column A you are getting the Updates. Replace the column name in line 6 with other if it differs.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim newVal As Variant
If Target.Count > 1 Then
If Intersect(Range("A:A"), Target) Is Nothing Then
Application.EnableEvents = False
Application.ScreenUpdating = False
newVal = Target.Value
Target.Offset(0, 1).Value = Target.Value
Target.Value = newVal
Application.ScreenUpdating = True
Application.EnableEvents = True
Note, as soon Excel update the Values in Column A you get Previous values in adjacent column.
Please do this,
- Select either entire Column A or required rows.
- Click conditional Formatting command.
- Then hit Highlight Cell Rules.
Then after Format one by one for **Equal to, Greater than & Less than conditions.
Remember, while Format only select Cell B2 for comparison.