Results 1 to 2 of 2

Vertical Conditional Formating for Current Fiscal Week (FW)

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    MS-Off Ver
    Office 365 - Version 2403
    Posts
    1,059

    Question Vertical Conditional Formating for Current Fiscal Week (FW)

    Hi,

    I have the following function that finds the current fiscal week (FW)& highlights the row.

    =$J5=$J$3 which the function is in the Conditional Formatting Rules Manager & using the following rule type:

    Use a Formula to determine which cells to format

    $J5 - Represents the first cell in the FW column

    $J$ - Represents the current FW, in this instance FW 20

    The above function works well to highlight the row or horizontally. Now, I would like to take a similar function that highlights the respective column or vertically.

    How would I modify?

    Thanks
    Last edited by mycon73; 05-13-2013 at 01:46 PM.
    MyCon
    -- Using Latest Version of Excel

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