+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting: Highlighting the value in a particular cell red

  1. #1
    Registered User
    Join Date
    05-29-2014
    Posts
    9

    Conditional Formatting: Highlighting the value in a particular cell red

    Hello all,

    I have a question on how to highlight a particular cell red if the value in one cell is less than or equal to the value in another cell.
    For instance, How do I make it so that the "Hours to go" cell turns red if the value in the "Actual Last Completion" value is less than or equal to the value of "Last Completed" cell?

    Thank you!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Conditional Formatting: Highlighting the value in a particular cell red

    =M12<=B12 in conditional formatting formula. Set the formatting to your desired shade of fill.

  3. #3
    Registered User
    Join Date
    05-29-2014
    Posts
    9

    Re: Conditional Formatting: Highlighting the value in a particular cell red

    Ahh would you mind showing me on the excel spreadsheet? It would help a lot!

  4. #4
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Conditional Formatting: Highlighting the value in a particular cell red

    RED CLOUD (SEMI) (1).xlsx

    Here it is. I'm not sure what you want to do if the "Actual Last Completion" is blank so I ignored it completely. If you wanted to highlight in red only if the cell wasn't blank then change the formula to =AND(M12<=B12,M12<>"")

+ 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] help in Highlighting a row using Conditional Formatting
    By civram1982 in forum Excel General
    Replies: 4
    Last Post: 02-06-2014, 03:50 AM
  2. Highlighting in Conditional Formatting
    By NETSPY in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-21-2013, 08:20 AM
  3. Conditional Formatting Highlighting
    By MPXJOHN in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2012, 04:07 PM
  4. Replies: 2
    Last Post: 06-01-2012, 06:36 PM
  5. [SOLVED] Conditional formatting and row highlighting
    By Cary in forum Excel General
    Replies: 3
    Last Post: 06-03-2005, 12:05 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