3 Color Scale Conditional Formatting for rows based on min and max FOR EACH ROW

Id prefer not to have to use VBA unless thats the only way.

The problem is I have 1000 rows of data with 12 columns (months) of revenue and I want to see the trend for each row colored. Each row has varying degrees of revenue though so they should be colored unique to that row.

Since you cant do a color scale based on values (min and max) Im not sure how to do it other than making 1000 different conditional formattings which isnt timely.

The example below is just me doing a conditional formatting for each row. Im not using the min and max but would like to. I stopped after 5 rows because its tedious...especially when dealing with 1000 rows.

There are instructions at the top of the page explaining how to attach your sample workbook.

In my opinion, it's rather stupid of Microsoft to offer formulae in colour scales settings, but not allow them to use relative cell references - if they did, this would be easy.

I suspect your only option will be VBA, but let's see what others come up with.

You may have gotten through by now, however I thought I would offer this anyway.
Set up a helper range in columns R:AD and populated using: =RANK.EQ(B2,$B2:$N2,1)
Select the range B2:N11
Apply formulas for rules for each of the 13 possible ranks, as in =R2=1 (red), =R2=13 (green) etc.
In the attached, six rules are applied for the 3 smallest and 3 largest values per row.
Let us know if you have any questions.