Results 1 to 3 of 3

Thread: Simple Excel Question

  1. Oct 26th, 2006, 11:37 AM #1
    vonoventwin
    vonoventwin is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2005
    Location
    Long Island, NY.
    Posts
    353

    Simple Excel Question

    I have a column F that has dates in it that I want to turn pink if they are 30 from the date entered. The format of the date entered is 11-Oct-06. I totally forget how to write this inside Visual Basic editor. Can I just use Conditional Formatting? How? Thanks in advance...
    Reply With Quote Reply With Quote
  2. Oct 26th, 2006, 11:46 AM #2
    malik641
    malik641 is offline
    Addicted Member malik641's Avatar
    Join Date
    Sep 2005
    Location
    South Florida :-)
    Posts
    221

    Re: Simple Excel Question

    Conditional formatting:

    Formula Is =(F1-TODAY())>=30





    If you find any of my posts of good help, please rate it
    Reply With Quote Reply With Quote
  3. Oct 26th, 2006, 01:31 PM #3
    vonoventwin
    vonoventwin is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2005
    Location
    Long Island, NY.
    Posts
    353

    Re: Simple Excel Question

    Thanks!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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


Click Here to Expand Forum to Full Width