+ Reply to Thread
Results 1 to 2 of 2

Applying Conditional formatting for entire Row based on date

  1. #1
    Registered User
    Join Date
    04-15-2008
    Location
    Tamil Nadu, India.
    MS-Off Ver
    Microsoft Office 2016
    Posts
    582

    Thumbs up Applying Conditional formatting for entire Row based on date

    Dear Friends,

    I am to apply conditional formatting coloring entire row based on the details as follows:

    Please Login or Register  to view this content.
    In the above example, I just need to color entire row based on value mentioned in Col W -(minus) Col H dates. i.e. I just want to be reminded that From today, what are the dates (in col H) falling adding the no. of days in Col W (55) (In the above example it is in Bold). If some dates are falling, then the entire row should be filled with Red.

    Thanking you,

    Yours, acsishere
    Last edited by acsishere; 11-14-2009 at 04:44 PM.
    Good friends are hard to find, harder to leave, and impossible to forget.

    acsishere.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,613

    Re: Applying Conditional formatting for entire Row based on date

    Select the entire sheet, then CF with:
    Please Login or Register  to view this content.
    Ben Van Johnson

+ 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