I'm looking to apply a conditional formatting based on below row.
Everyday a add a new row to update previous dates value.
See attached for e.g.
Today I added a new row at row no. 5 to update cost of yesterday's date i.e. for 5th May 2021.
Now I want to check if cost of row 5 is less or greater than row no. 6.
Cost of cell B5 and C5 is greater then B6 and C6, so B5 and C5 cell color should get updated with green color.
And the cost of D5 is less then D6, so it should get updated with red color.
And tomorrow when I add a new row to update cost for 6th May, we should check the cost with 5th May cost.