1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Conditional Format

Discussion in 'Business Applications' started by mrl, Aug 7, 2011.

Thread Status:
Not open for further replies.
Advertisement
  1. mrl

    mrl Thread Starter

    Joined:
    Aug 12, 2007
    Messages:
    331
    Hi,
    I'm trying to have the format in selected cells change color when a certain cell has today's date in it, and stay changed.
    I highlighted the cells that I want to change, then I went to Conditional Formatting and made a new rule

    HTML:
    =b2=<now()
    It works fine without the less than symbol

    what am I doing wrong? :confused:

    Mike
     
  2. Pedro15

    Pedro15

    Joined:
    Oct 5, 2008
    Messages:
    386
    No solution to your problem and trying to test various ideas I came up with the thought that conditional formatting as Now() with say a Red pattern will only bring up a red coloured cell today because that is what now() does.

    So what is the sequence of events that will lead up to date becoming today's date?

    I have a cash book where certain bill are paid by direct debit.

    I enter the date due in column A and have the following formula to change the cell colour to red if the date is ahead of current date.

    It is (copied down)

    Code:
    =AND(ISNUMBER($A9),TODAY()<$A9)
    Cell colour disappears when the due date is reached.

    Perhaps there may be another way to look at your problem.

    Pedro
     
  3. mrl

    mrl Thread Starter

    Joined:
    Aug 12, 2007
    Messages:
    331
    Hi Pedro 15, :)
    I'm using a calander and I post bills dues in red.
    When the day hits, I want the bills to turn blue and stay like that.
    After I asked the question, I thought about using a macro to find the date and turn everything in the square blue, but I can't think of a way to keep it that way.

    Mike
     
  4. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,608
    First Name:
    Hans
    If you set the conditional format to compare the date due <= today() then it will remain so any date prior to the date due and stay blue. (?)
     
  5. mrl

    mrl Thread Starter

    Joined:
    Aug 12, 2007
    Messages:
    331
    Hi Hans
    I see my error. I had the < after the = sign and Now() should be Today()
    Thanks

    and thanks Pedro 15, too

    Mike :D
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - Solved Conditional Format
  1. Squashman
    Replies:
    5
    Views:
    352
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1011185

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice