+ Reply to Thread
Results 1 to 7 of 7

Conditional Formatting with Offset Formula

  1. #1
    Registered User
    Join Date
    03-12-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2003
    Posts
    55

    Conditional Formatting with Offset Formula

    Hi Experts,

    How can i highlight the cells with offset formula ? or any other way to do this. Thanks in advance


    Capture.PNG
    Attached Images Attached Images

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Conditional Formatting with Offset Formula

    May be something like this (its a bit hard with out your spreadsheet).

    Use this as a conditional formula

    Please Login or Register  to view this content.
    Happy with my advice? Click on the * reputation button below

  3. #3
    Registered User
    Join Date
    03-12-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2003
    Posts
    55

    Re: Conditional Formatting with Offset Formula

    Thank you sir , its highlighing but wrong cells , here is the file i attached
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-12-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2003
    Posts
    55

    Re: Conditional Formatting with Offset Formula

    thank you , some corrections , this works for me <3
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-12-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2003
    Posts
    55

    Re: Conditional Formatting with Offset Formula

    Quote Originally Posted by Crooza View Post
    May be something like this (its a bit hard with out your spreadsheet).

    Use this as a conditional formula

    Please Login or Register  to view this content.
    Some Error , i will wait for ur solution

  6. #6
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Conditional Formatting with Offset Formula

    Try this

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    03-12-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2003
    Posts
    55

    Re: Conditional Formatting with Offset Formula

    Fantastic, Its works... Thank you, Sir

    Quote Originally Posted by Crooza View Post
    Try this

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional formatting with offset
    By Jeff SG in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-18-2019, 10:56 PM
  2. Conditional Formatting of cell value with an offset
    By JoshWinks in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-01-2019, 07:14 PM
  3. [SOLVED] VBA Conditional formatting with cell offset
    By Tanabar in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-14-2014, 03:23 PM
  4. [SOLVED] Conditional Formatting Offset
    By tommy_m in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-16-2012, 04:41 PM
  5. Offset in conditional formatting
    By Diddy in forum Excel General
    Replies: 1
    Last Post: 03-27-2011, 12:07 PM
  6. Offset conditional formatting
    By Ducatisto in forum Excel General
    Replies: 7
    Last Post: 10-03-2008, 03:55 AM
  7. Conditional Formatting - offset ?
    By HUMBERTDING in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-09-2008, 05:32 AM

Tags for this Thread

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