Excel » Conditional formatting » CF-formatting »

Drop down list changes cell formatting

You can apply different conditional formatting formulas and formatting to a cell range, using a drop down list. Here is […]

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 […]