Conditional Formatting if cell is Blank
 

So, it's been a while since I've done conditional formatting, and I'm trying
to format an entire column where the cell turns green if it's blank. I know
it's easy, but I can't seem to find it in 2007.

Thanks!

Judi

Answer: Conditional Formatting if cell is Blank
 

Hi Judi!

No worries, I'm here to help! Here's how you can apply conditional formatting to turn a cell green if it's blank:

1. Select the entire column that you want to apply the conditional formatting to.
2. Click on the "Home" tab in the ribbon.
3. Click on "Conditional Formatting" in the "Styles" group.
4. Select "New Rule" from the drop-down menu.
5. In the "New Formatting Rule" dialog box, select "Use a formula to determine which cells to format."
6. In the "Format values where this formula is true" field, enter the formula
   Formula:

   ---

   "=ISBLANK(A1)" 


   ---

   (assuming your selected column starts with cell A1).
7. Click on the "Format" button.
8. In the "Format Cells" dialog box, select the "Fill" tab.
9. Choose the green color that you want to use.
10. Click "OK" to close the "Format Cells" dialog box.
11. Click "OK" again to close the "New Formatting Rule" dialog box.

Now, any cell in the selected column that is blank will be formatted with the green color you chose.

Conditional Formatting if cell is Blank
 

--From HomeTabStylesConditional FormattingHighlight cell RulesEqualto

--In the 'Format cells that are equal to:' enter the below

=""

--Select the color and press OK

If this post helps click Yes
---------------
Jacob Skaria


"Judi" wrote:

So, it's been a while since I've done conditional formatting, and I'm trying
to format an entire column where the cell turns green if it's blank. I know
it's easy, but I can't seem to find it in 2007.

Thanks!

Judi

Conditional Formatting if cell is Blank
 

Thank you!

"Jacob Skaria" wrote:

--From HomeTabStylesConditional FormattingHighlight cell RulesEqualto

--In the 'Format cells that are equal to:' enter the below

=""

--Select the color and press OK

If this post helps click Yes
---------------
Jacob Skaria


"Judi" wrote:

So, it's been a while since I've done conditional formatting, and I'm trying
to format an entire column where the cell turns green if it's blank. I know
it's easy, but I can't seem to find it in 2007.

Thanks!

Judi