+ Reply to Thread
Results 1 to 2 of 2

Highlighting input spaces

  1. #1
    Registered User
    Join Date
    03-04-2005
    Location
    Sheffield, UK
    Posts
    2

    Question Highlighting input spaces

    I have an excel sheet in which people fill in data everyday, I have a date column that using conditional formatting highlights todays date, however it would be easiest if I could get the whole row to highlight instead of just the one cell down one side, is there any way this can easily be done?

  2. #2
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474
    Assuming that A2:G10 contains your data, and Column B contains your date...

    1) Select your data, for this example A2:G10

    2) Format > Conditional Formatting > Formula Is

    3) Enter the following formula:

    =$B2=TODAY()

    4) Choose your formatting

    5) Cick Ok

    Hope this helps!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1