Results 1 to 5 of 5

Conditional formatting formula range update

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-03-2005
    Posts
    185

    Conditional formatting formula range update

    Hi - I set up a table and conditional formatting rules so that when I type any value in M3 and N3, appropriate cell in the table is highlighted. The corners of the table work correctly but rest of the table doesn't. I am using version 2013 but in previous versions you can specify a range to apply a conditional formatting to and the formula to drive the conditional formula will adjust if you set up the absolute and relative references (with $ sign and without $ sign) correctly. I did set up the formula correctly but it doesn't seem to be adjusting when I select a cell in the table. I think that is the reason why my conditional formatting is not working and I was hoping there is a solution for that instead of me specifying a conditional formatting for each cell separately (this is just a sample, my actual table is log bigger).

    Can someone please help me and look at the attached file and let me know why my conditional formatting is not working (either because of what I think above or something else)? Otherwise, does someone have any better idea to do this so that appropriate cell in the table is highlighted if I type in two values in column M and N?

    Thank you so much in advance,
    Jay
    Attached Files Attached Files
    Last edited by sa02000; 03-12-2014 at 06:45 PM. Reason: Mark Solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 07-30-2012, 01:48 AM
  2. [SOLVED] conditional formatting formula to search a range of cells
    By drfarmkid in forum Excel General
    Replies: 2
    Last Post: 06-19-2012, 03:25 PM
  3. Conditional formatting formula -Data range?
    By elfiky in forum Excel General
    Replies: 2
    Last Post: 09-27-2011, 02:44 AM
  4. highlight comparison using conditional formatting with formula in range
    By tjc0ol in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-29-2011, 08:48 AM
  5. Conditional formatting with formula referencing range in different cell
    By pethaa1791 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-21-2008, 03:54 PM

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