1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel conditional formatting help

Discussion in 'Windows & Other Software' started by Mark M, 16 Sep 2009.

  1. Mark M

    Mobster

    Joined: 6 Jan 2006

    Posts: 3,210

    Location: Newcastle upon Tyne

    Im pulling together a sheet of deadlines and have conditionally formatted the cells so that when the date exceeds the deadline they will turn red by using the follow condition:

    If cell value is less than [todays date] then colour cell red.

    Now this works fine but it sadly also colours any cell that is blank in red too.

    Ideally I wanted to apply the formatting to the whole colum so I can just add in new entries with upcoming deadlines and not have to worry about the formatting of it.

    Can you think of anyway of doing it?

    Thanks, Mark
     
  2. Dolph

    Man of Honour

    Joined: 17 Oct 2002

    Posts: 48,419

    Location: Plymouth

    Add an additional condition that if cell is empty ("") or null then it remains unfilled is the way I normally deal with that.
     
  3. Mark M

    Mobster

    Joined: 6 Jan 2006

    Posts: 3,210

    Location: Newcastle upon Tyne

    Many thanks Dolph, worked a treat. I had to add the new conditional as the first one for it to work but I assume thats fine as it works great.
     
  4. PMKeates

    Capodecina

    Joined: 16 Jul 2004

    Posts: 14,043

    In case you run out of conditions this will do it in one:

    =AND(A1<TODAY(),A1<>"")