Advanced Search

Change Excel Cell Colors based on whether they contain data or not

/ Published in: Other
Save to your folder(s)
This formula will automatically change a cell's background color if there is data in it. You can also change the formula to only fill cells where there is no data.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. Select your cells you want to apply this formula to. E.g. - All of column B
  2. Select Conditional Formatting.
  3. Choose New Rule - Use a formula to determine which cells to format
  4. To change only cells with data enter the following:
  5.               =B1<>""
  6. To only change those cells without data enter the following
  7.               =B1=""
  8. Select the format button and apply whatever format you would like to the cell - fill, font, border...
  9. Click OK to apply.

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.