+ Reply to Thread
Results 1 to 3 of 3

how to highlight through conditional formatting

  1. #1
    Registered User
    Join Date
    05-07-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    23

    how to highlight through conditional formatting

    Hi,

    Please see attached. If the Actual Yield is less than the target yield on the same line, I want to highlight it in red.

    Thanks
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: how to highlight through conditional formatting

    1st Google result http://office.microsoft.com/en-gb/ex...102809768.aspx
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Registered User
    Join Date
    05-07-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: how to highlight through conditional formatting

    Thank you!

+ 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. [SOLVED] Conditional formatting to highlight a value
    By Anuru in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-06-2014, 02:25 PM
  2. [SOLVED] Conditional formatting: Highlight second or more row
    By ExcelStefan in forum Excel General
    Replies: 1
    Last Post: 07-09-2012, 03:04 AM
  3. [SOLVED] Conditional Formatting for highlight
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-06-2012, 10:42 AM
  4. how to highlight a row using conditional formatting ?
    By ziva770 in forum Excel General
    Replies: 5
    Last Post: 11-27-2010, 01:30 PM
  5. Replies: 2
    Last Post: 08-16-2009, 06:16 PM

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