+ Reply to Thread
Results 1 to 2 of 2

Highlight Cells rule

  1. #1
    Registered User
    Join Date
    03-28-2016
    Location
    Spain
    MS-Off Ver
    MS Office 2013
    Posts
    1

    Highlight Cells rule

    Hello I’m struggling to define this ‘Highlight Cell Rule’:

    · Rule 1) Cells (I5:J578) will be highlighted in red if the value is < 0,3333;
    · Rule 2) Cells (I5:J578) will be highlighted in orange if value is > 0,35416;
    · Rule 3) However these mentioned highlights should only occur when the corresponding row cells (C:F) are filled with the hours.

    I’m able to define the simple highlight rule (e.g. red if the value is < 0,3333), but this way makes all the cells highlighted in red until its result is < or > than 0,333. What I’m trying to achieve is:
    o The cell has white background, and will only be highlighted according to ‘Rule 1’ and ‘Rule 2’, but after the dates insertion in cells (C:F).
    Could someone help me on this issue?
    Thanks in advance.

    excel_hours.jpg

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Highlight Cells rule

    Hello,

    any particular reason why you use two rows and two columns for every cell instead of just resizing the row height and column width?? That approach with merged cells can turn out very ugly.

    In any case, you need two rules. Select cell I5 and apply

    =AND($C5>0,$E5>0,I5>0.35416) -- for orange

    =AND($C5>0,$E5>0,I5<0.33333) -- for red

    Then apply the format to the desired range.

    cheers, teylyn

+ 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 multiple values with single rule?
    By chapzboy in forum Excel General
    Replies: 13
    Last Post: 05-28-2015, 03:02 AM
  2. New User..Need help with CF,New Rule. Highlight Adjacent Cells with Border
    By Moondolphan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-27-2015, 08:00 PM
  3. [SOLVED] A conditional formatting rule that will highlight a cell based on certain criteria/date
    By FEL2014 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-24-2014, 03:51 PM
  4. Replies: 5
    Last Post: 07-03-2013, 12:51 AM
  5. [SOLVED] Conditional Rule to highlight
    By Jiptastic in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-29-2013, 01:03 PM
  6. Need to create rule for auto highlight
    By xyzco123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-21-2011, 07:16 AM
  7. [SOLVED] Highlight cells with ctrl-click but only un-highlight one cell
    By hagan in forum Excel General
    Replies: 5
    Last Post: 05-27-2005, 02: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