Excel - conditional formating

Dear Daryl

Thank you for attending Excel Advanced course!! I hope you enjoyed the course and benefited from it.


Please follow these simple steps to achieve your result:

1. Select all the cells that you wish to apply the conditional Formatting to

2. Choose Format > Conditional Formatting

3. Ensure that first box displays cell value is and then choose Equal to from the second drop down box

4. In the last box type =""

Step 5: click on the Format.. button and choose the relevant formatting that you want to be displayed on the selected cells

Step 4 ensures that the formatting is applied to Blank cells only!! Please note that there are no spaces between the Inverted commas. (this is the SHIFT + 2)

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007