Tag Archives: Excel conditional formatting

Conditional Formatting in Excel – One column based on another

[table] Match1, Match2 A, B D, A E, E F, D K, K [/table] Rule: COUNTIF($B$2:$B$6,C2) Read: If cell c2 value exists in the range B2:B6, then highlight the cells that I have selected in step 1. The above will … Continue reading

Posted in Tutorials/Tips | Tagged , | 1 Comment

Conditional formatting in Excel – Highlight if greater than left adjacent

You might come across a situation where you want to highlight a value if it is greater than its counter its left adjacent value. For example [table] Col A, Col B 1,3 2,1 3,5 [/table] In the above case you … Continue reading

Posted in Software Development | Tagged , | Leave a comment