Posted By

kidmizere on 06/13/13


excel colors

Versions (?)

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

 / Published in: Other

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.

  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  

You need to login to post a comment.