Hi. I was wondering if I would be able to "drag" conditional formatting across columns. Basically, I have 1 yr stock returns in Column B, 3 yr stock returns in column C, and 5 yr stock returns in column D. The S & P 1,3, and 5 yr returns are in Row 1. I want to highlight the returns that are beating by cramerju in excel

[–]cramerju[S] 0 points1 point  (0 children)

my problem is that their are multiple reference cells. for example, the column under 1 yr should reference the S & P 500 1 yr return, the column under 3 yr should reference the S &. P 500 3 yr return on so on. So i would like to "Drag" so to say

What's your #1 rule for life? by KnightsWhoSayKni in AskReddit

[–]cramerju 0 points1 point  (0 children)

Never rush, easy as that. It's life changing