Using Conditional Formatting to highlight a cell based on an adjacent cell, but only if the cell being formatted is blank. The other answers seem largely correct, except it should be, as far as I understand Select column D. Home Conditional Formatting Highlight cell rules More rules, then select use a formula etc. Book Cover Page Design Templates. Formula ANDA1Closed,D1. Crack Memories On Tv 3.1.8 more. And dont forget to set the formatting. Is there a way to add padding to cells in Excel 2010 The spreadsheet Im using has cells in one column with varying row heights. I dont want to center the text, I. Windows 7 Pro Oa 64 Bit Iso'>Windows 7 Pro Oa 64 Bit Iso. Let me tell you about the useful shortcut keys F2 Edit the selected cell. F5 Go to a specific cell. F7 Spell check selected text andor document. F11 Create chart.