I am seeking each cell to the right to highlight (red if increase, green if decrease, yellow if same). I.e. D8 is less than D7, so it would be green. How would I apply this to all rows?
I am seeking each cell to the right to highlight (red if increase, green if decrease, yellow if same). I.e. D8 is less than D7, so it would be green. How would I apply this to all rows?
Try these conditional format formula![]()
Please Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
In post #1 it states "I am seeking each cell to the right to highlight" however D8 is below D7, not to the right.
Assuming that the desired outcome is to highlight cells to the right the rules could be:
=D7<E7 red
=D7>E7 green
=E7=E7 yellow
Note that the rules are applied to E7:Z26 because there are no values to the left of column D.
Note that rows 7:26 have only these three rules applied.
Note that rows 28:47 are populated using: =D7>E7 only to illustrate how the relative reference formula will change as it is applied to different rows and different columns.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks