Results 1 to 3 of 3

conditional formatting

This is a discussion on conditional formatting within the Excel Questions forums, part of the Question Forums category; All I want to do is have excel highlight cells that are blank. ie 0-infinity no highlight, blank cells highlighted. ...

  1. Dec 19th, 2003, 04:59 AM #1
    TODDY
    TODDY is offline
    New Member
    Join Date
    Sep 2003
    Posts
    21

    Default conditional formatting

    All I want to do is have excel highlight cells that are blank. ie 0-infinity no highlight, blank cells highlighted.
    I have tried <0 with no joy, if I enter -1 its ok but not if the cell is blank.
    Regards
    Reply With Quote Reply With Quote
  2. Dec 19th, 2003, 05:10 AM #2
    Andrew Poulsom
    Andrew Poulsom is offline
    MrExcel MVP
    Moderator     Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    58,750

    Default Re: conditional formatting

    Have you tried ="" ?
    Reply With Quote Reply With Quote
  3. Dec 19th, 2003, 05:18 AM #3
    TODDY
    TODDY is offline
    New Member
    Join Date
    Sep 2003
    Posts
    21

    Default Re: conditional formatting

    fantastic many thanks for helping with such a simple problem.
    all good wishes for the season
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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
  •  

Forum Rules


DMCA.com