+ Reply to Thread
Results 1 to 3 of 3

conditional format an empty cell

Hybrid View

lilsnoop conditional format an empty... 04-14-2007, 07:06 PM
Paul Select cells C2:C24, click... 04-14-2007, 07:20 PM
lilsnoop Thank You! 04-14-2007, 07:55 PM
  1. #1
    Valued Forum Contributor
    Join Date
    03-17-2007
    Location
    Michigan
    MS-Off Ver
    Excel 2021
    Posts
    974

    conditional format an empty cell

    Anyone have a suggestion how I might be able to conditionally format an empty cell? I have a column formatted for numbers, which could contain anything from a "0" up numerically. The problem is that I might also have a cell which may not have anything in it and its those cells that I'd like conditionally format to a color. I thought I could use an IF formula like =IF(C2:C24<0,""), but that didn't work... Any help would be greatly appreciated. Thanks in advance! I see someone asked a similiar question and I found the answer... thanks...
    Last edited by lilsnoop; 04-14-2007 at 07:20 PM.

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887
    Select cells C2:C24, click Format > Conditional Formatting

    Change 'Cell value is' to 'Formula is', and use this formula:

    =C2=""

    Change the background color as needed and click OK. Those cells that are empty will now be the color you chose.

  3. #3
    Valued Forum Contributor
    Join Date
    03-17-2007
    Location
    Michigan
    MS-Off Ver
    Excel 2021
    Posts
    974

    Thank You!

    Thanks for your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1