Microsoft Office Forums - View Single Post - Conditional Fomatting Formats Next Cell

Thread: Conditional Fomatting Formats Next Cell

View Single Post

Old

05-31-2017, 11:01 AM

Phil H

Phil H is offline

Phil H uses Windows XP

Windows XP Phil H uses Office 2010 64bit

Phil H uses Office 2010 64bit

Office 2010 64bit

Advanced Beginner

The original poster

Join Date: Jun 2010

Posts: 81

Phil H is on a distinguished road

Default

Conditional Fomatting Formats Next Cell

Conditional formatting formula: =isblank; applies to: =$Z$3:$Z$37
If any cell in the range is cleared (using delete key), the next cell in the range is formatted, not the original cell. For example, cell Z10 is cleared, cell Z11 is formatted. Why?

Reply With Quote