+ Reply to Thread
Results 1 to 3 of 3

Conditional Formating

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    02-04-2008
    MS-Off Ver
    Microsoft Office 2007
    Posts
    261

    Conditional Formating

    Dear All,

    Please find the attached demo file..

    Need to apply a conditional formatting on table 2 values (G3:G7) condition is if G3 is not equal to D3 then fill color should
    apply on the entire rows of the Table,(F3:G3)

    I am using ms excel 2010,earlier versions i have applied formulas to workout on conditional format,now i can't figure out.


    Thanks In Advance,
    Ak
    Attached Files Attached Files

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Conditional Formating

    In CF rule use

    =$G3<>$D3 -- format red

    See attached
    Attached Files Attached Files
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Contributor
    Join Date
    02-04-2008
    MS-Off Ver
    Microsoft Office 2007
    Posts
    261

    Re: Conditional Formating

    Thanks Ace..

+ 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