Excel » Conditional formatting » CF-formatting »

How to change cell formatting using a Drop Down list

This article demonstrates how to apply different cell formatting to a cell range based on a Drop Down list, column […]

Dynamic formatting

Question: I have a list that I keep adding rows to. How do i create a border that expands as […]

Highlight every other row

Here is how to highlight every other row using conditional formatting. Conditional formatting formula: =ISEVEN(ROW())*OR($B3:$D3<>"") Alternative CF formula: =EVEN(ROW())=ROW() This […]