Solutions to the Problem Conditional Formatting: "Format values where this formula is true" - How do I ensure that the formula fills down?

It sounds like you only applied the Conditional Formatting rule to a single cell.Select the entire area that you want to apply the Conditional Formatting to.Then recreate the rule using your =ISBLANK(A8) formula where A8 is the cell in the top-left corner of the area you selected.As noted by HansV above, the lack of dollar signs ($'s) for relative positioning is important.

When you have completed this, you can use Conditional Formatting, Manage Rules to delete the original rule.

Make Sure that your Computer Meets the System Requirements

Microsoft Windows Requirements :

1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor

1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)

16 GB available hard disk space (32-bit) or 20 GB (64-bit)

This error can be due to some configuration requirements for you system. If your computer hardware is not up to par, then make sure you update where necessary before continuing.

Another Safe way to Repair the Problem: Conditional Formatting: "Format values where this formula is true" - How do I ensure that the formula fills down?:

How to Fix Conditional Formatting: "Format values where this formula is true" - How do I ensure that the formula fills down? with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system. Run it, and it will scan your computer. The errors will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems need to be fixed. Click Fix All.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been fixed