Results 1 to 27 of 27

Conditional Format

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-28-2004
    Location
    Tokyo
    MS-Off Ver
    Office 2016 pro plus
    Posts
    175

    Conditional Format

    I have a simple spreadsheet and am trying to get rows or cell (which ever one is easier but prefer row) to highlight Red, Yellow, and Green.

    When the date in F3 is within Equal to or less than 50 days from H3 I want the row or cell F3 to turn red
    When the date in F3 is within Equal to or less than 51-60 days from H3 I want the row or cell F3 to turn Yellow
    When the date in F3 is within Equal to or less than 61 or more days from H3 I want the row or cell F3 to stay green


    On a different topic. The days the reports are due are different from Foreman and Superintendent. Is it possible to automatically adjust the formula I have in Column F & G?

    When I select Foreman, I want the formula in column F to be =H3-50 and G to be =H3-40
    When I select Superintendent, I want the formula in column F to be =H3-55 and G to be =H3-45


    The most important part right now is the conditional, I appreciate any help. Thank you
    Attached Files Attached Files

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