Conditional formatting with colour and values

Hi Please help,

I have a row of values which updates daily, I then also have a upper limit say of 10 and a button limit of say 5.

As soon as a number in the row of values go beneath the bottom limit then the conditioning formatting must activate.

I need the conditional formatting to check the daily value when it is below the bottom limit, it must check the previous days value and if it is more than the previous day it need the cell fill color changed (say red). The number must stay red until it is over the upper limit and more then the previous day.

Hope this make sense.

Re: Conditional formatting with colour and values

Hi please see the attached an example maybe it will explain it a bit better. I am not very good with macros sorry.

Quote from venkat1926;661348

depends upon data congifuration. no data is given
following sample trivial data from A1 to B9.

date price
1-Apr 3
2-Apr 5
3-Apr 2
4-Apr 5
5-Apr 8
6-Apr 2
7-Apr 6
8-Apr 2

try this macro on THIS SAMPLE DATA
If you get what you want modify macro to lsuit you.

Sub test()
Dim r As Range, c As Range

Code

Worksheets("sheet1").Activate
Cells.Interior.ColorIndex = xlNone
Set r = Range(Range("B3"), Cells(Rows.Count, "B").End(xlUp))
For Each c In r
If c <= 5 Then
If c <= c.Offset(-1, 0) Then
c.Interior.ColorIndex = 3
End If
End If
Next c
End Sub

Display More

Display More