When it comes to conditional formatting not being applied to all cells, here are some steps you can take to resolve the problem:
- Check that the range is set correctly – the cell range you are attempting to format may be incorrect, or incorrect cell criteria could be entered.
- Look for incompatibilities – if array formulas or data validation is enabled, this may cause a conflict with the conditional formatting.
- Verify the formula syntax – check the formula syntax and make sure that it matches the criteria you are expecting.
- Check for missing cell references – missing references in the conditional formatting formula may cause cells to be excluded.