Conditional Formatting question....

Discussion in 'Excel' started by exconrailchris, Oct 1, 2017.

  1. exconrailchris

    exconrailchris

    Joined:
    Apr 14, 2016
    Messages:
    5
    Likes Received:
    0
    Location:
    Bucks County PA
    Can I set a conditional format function to highlight a row containing todays date ? the row would be about 18 columns wide and change as the date does.........
     
    exconrailchris, Oct 1, 2017
    #1
    1. Advertisements

  2. exconrailchris

    Luck

    Joined:
    Dec 28, 2017
    Messages:
    8
    Likes Received:
    0
    Suppose date in A1:A10. Then, select that range and create a conditional format. Select 'Use a formula to determine which cells to format' and specify the formula =TODAY()=A1. Specify the format as desired.
     
    Luck, Dec 30, 2017
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.