Excel Highlight Cell based

Copper Contributor

Hi All,

I have a row from A1:P1 with some values in each cell. Now I want to fill the cell eg B1 if it's value is greater then previous cell eg. A1 value. I don't want to do it one by one by using conditional formatting for each cell to fill the whole row data.

In below attachment B1 is filled with yellow because it's value is greater than previous cell A1 and so on for each next cell respectively.   

Cell Highlighted.png  

Thanks,

0 Replies