Ask Your Question

Conditional formatting across columns, by row

asked 2020-05-01 22:26:22 +0200

AndyNoCo gravatar image

updated 2020-05-01 22:32:34 +0200

I have three columns (M, P, and S), and I want the values in each row's cells to have conditional formatting so that the lowest value in that row is my "Red" style, the median value in that row is my "Yellow" style, and the maximum value in that row is my "Green" style. I want the conditional formatting for each row, not each column.

So far, I can only figure out how to do this one row at a time. In Format > Conditional > Manage... there are currently 10 separate conditional formats - one for each row. When I insert a new row at the bottom, the new row's conditional formatting references are to the previous row number. ("Expand references" is enabled in Preferences.) I have to delete the new row's conditional formatting, and enter new conditional formatting for that row.

Is there a way to create one conditional format for the three column ranges (currently M6:M16, P6:P16, and S6:S16), so that IN EACH ROW, the minimum is Red, the median is Yellow, and the Maximum is Green? AND... when I insert row 17, the conditional formatting will carry over, and its cells will be minimum Red, median Yellow, and maximum Green FOR ROW 17? Thanks.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-05-01 23:22:40 +0200

@AndyNoCo, Below is an example file, with 3 conditional formats, one for each column.

image description

image description

image description


ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.

If the answer met your need, please click on the ball Descrição da imagem to the left of the answer, to finish the question.

edit flag offensive delete link more



How obvious! (And how embarrassing.) I was trying to apply conditional formatting to all three columns at the same time. When someone starts thinking in one way, it can be almost impossible to start over and think in a different way. Muito obrigado, senhor.

AndyNoCo gravatar imageAndyNoCo ( 2020-05-02 03:19:54 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-05-01 22:26:22 +0200

Seen: 23 times

Last updated: May 01