fill colour
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: fill colour

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Tony Gennoe
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I want to fill a cell colour ie G6 when a date is entered in E6. How do i do it please?

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Use conditional Formatting in G6
    Choose the 'Formula Is' Option
    Enter =ISNUMBER(E6)

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    142
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Use conditional formatting...

    cell value - not equal to - $E$6

    Change the cell shading to the desired color within the Conditional Formatting dialogue box.

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Some more restrictive format conditionals include...

    =AND(E6>"12/31/2001"+0,LEFT(CELL("format",E6))="D")

    ...which differentiates between "any old number" and a datevalue beyond 2001. Furthermore, it
    requires E6 to be formatted to "look" like a date.

    [ This Message was edited by: Mark W. on 2002-04-04 12:24 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com