+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting Question

  1. #1
    Registered User
    Join Date
    05-13-2013
    Location
    York, PA
    MS-Off Ver
    Excel 2010
    Posts
    13

    Conditional Formatting Question

    I have an accounts receivable list with the invoice date and amount listed in two different columns side by side. I've conditionally formatted the Invoice date to change colors when it is greater than 60 days, 90 days, etc. How do I get the amounts to change the same color as the invoice dates?

    Thank you so much!

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,003

    Re: Conditional Formatting Question

    Select Date/Amount fields together and set CF on Invoice Date

  3. #3
    Registered User
    Join Date
    05-13-2013
    Location
    York, PA
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Conditional Formatting Question

    Thank you! I tried that. What formula would I use to Conditionally Format?

  4. #4
    Registered User
    Join Date
    03-08-2017
    Location
    rhode island
    MS-Off Ver
    office 2013
    Posts
    3

    Re: Conditional Formatting Question

    Rule:
    "=$E2:$E58>=90" will look for anything in column E that is 90 or higher.
    Apllies to:
    "=$A$2:$F$58" will highlight all cells from A to F in any row that E is 90 or higher.

    I hope this helps.

+ 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. Conditional Formatting Question
    By lbickford in forum Excel General
    Replies: 9
    Last Post: 11-17-2016, 05:09 PM
  2. conditional formatting question
    By fivestar17 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 08-30-2013, 10:02 PM
  3. [SOLVED] Another Conditional Formatting question
    By swmwshrk in forum Excel General
    Replies: 12
    Last Post: 07-11-2012, 02:43 PM
  4. [SOLVED] Conditional Formatting Question
    By aborg88 in forum Excel General
    Replies: 8
    Last Post: 04-26-2012, 05:22 AM
  5. Conditional Formatting Question
    By Bryce.Carter in forum Excel General
    Replies: 1
    Last Post: 10-18-2010, 03:05 PM
  6. Conditional Formatting question...
    By Dino in forum Excel General
    Replies: 5
    Last Post: 11-18-2005, 07:48 PM
  7. Another Conditional Formatting Question
    By MEL79 in forum Excel General
    Replies: 5
    Last Post: 03-12-2005, 06:14 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