LinkBack URL
About LinkBacks
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?
Conditional Formatting Question
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
Originally Posted by popipipo
Try these conditional format formulaPlease Login or Register to view this content.
How would I apply this to the entire sheet? I don't want all of them to compare their value to D7, yet, the cell to their left for each cell moving right.
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)
Posting Permissions
Register To Reply
Bookmarks