Results 1 to 13 of 13

Conditional Formatting

Threaded View

steve 1962 Conditional Formatting 06-13-2012, 09:39 AM
NBVC Re: Conditional Formatting 06-13-2012, 10:10 AM
steve 1962 Re: Conditional Formatting 06-14-2012, 04:41 AM
NBVC Re: Conditional Formatting 06-14-2012, 08:07 AM
steve 1962 Re: Conditional Formatting 06-14-2012, 08:44 AM
steve 1962 Re: Conditional Formatting 06-14-2012, 09:09 AM
NBVC Re: Conditional Formatting 06-14-2012, 09:24 AM
steve 1962 Re: Conditional Formatting 06-14-2012, 09:53 AM
steve 1962 Re: Conditional Formatting 06-14-2012, 09:53 AM
steve 1962 Re: Conditional Formatting 06-17-2012, 08:15 AM
NBVC Re: Conditional Formatting 06-14-2012, 09:23 AM
NBVC Re: Conditional Formatting 06-18-2012, 08:03 AM
steve 1962 Re: Conditional Formatting 06-19-2012, 06:22 AM
  1. #7
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Conditional Formatting

    Select from C3:K44 and re-invoke conditional formatting, change the Applies to range to =$C$3:$K$45 and then select the condition and click Edit and change formula slightly to:

    =$K3=INDEX($K$3:$K$45,MATCH(TRUE,$K$3:$K$45>=$M$1,0))

    The $ forces all cells to look at column K for conditional check and format.
    Attached Files Attached Files

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