+ Post New Thread
Results 1 to 4 of 4
Windows Thread, Help with conditional formatting in Technical; I have an excel table that i want to apply some conditional formatting to. I would like it so that ...
  1. #1
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    561
    Thank Post
    59
    Thanked 16 Times in 15 Posts
    Rep Power
    18

    Help with conditional formatting

    I have an excel table that i want to apply some conditional formatting to.

    I would like it so that if a value (any value) is added to cell I6, the other cells font colour changes. The formula i have below does the job but also applies this formatting if there is no entry present in cell I6. I only want this to happen if something is entered into this cell. Can anyone help

    =$I6<=TODAY()

  2. #2
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    561
    Thank Post
    59
    Thanked 16 Times in 15 Posts
    Rep Power
    18

    Re: Help with conditional formatting

    A little more playing about and i've made progress if i remove "<" from the formula this doesn't apply if there is nothing present in this cell but now it's just applying if todays date is entered. I want this to apply if any date is entered today or past. That's why i was trying to figure out if this could be triggered by any value entered in the cell.

  3. #3
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    561
    Thank Post
    59
    Thanked 16 Times in 15 Posts
    Rep Power
    18

    Re: Help with conditional formatting

    Should have had a play for just a little longer before i posted

    Adding
    =AND($I6<TODAY(),$I6>TODAY()-356)
    as a second conditional rule as solved this.

    Now i just need to find out how to apply this same formatting to all the rows in my table without having to do each one manually. Anyone?

  4. #4
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    561
    Thank Post
    59
    Thanked 16 Times in 15 Posts
    Rep Power
    18

    Re: Help with conditional formatting

    lol i figured that one out aswell. I'm going to shutup now

SHARE:
+ Post New Thread

Similar Threads

  1. Webpage formatting problem using Publisher
    By laserblazer in forum Web Development
    Replies: 8
    Last Post: 29th October 2007, 09:34 AM
  2. Replies: 5
    Last Post: 4th June 2007, 09:10 PM
  3. Formatting inside code block
    By ITWombat in forum Comments and Suggestions
    Replies: 4
    Last Post: 16th October 2006, 08:34 AM
  4. formatting w98
    By chrbb in forum Windows
    Replies: 6
    Last Post: 21st February 2006, 11:36 AM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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