+ Reply to Thread
Results 1 to 2 of 2

Changing FONT and Fill color based on Multiple Criteria

  1. #1
    Forum Contributor
    Join Date
    03-06-2020
    Location
    INDIA
    MS-Off Ver
    2007
    Posts
    113

    Changing FONT and Fill color based on Multiple Criteria

    I have 13 worksheets ( sheet 1 being MAIN and remaining sheets 2 - 13 are Months(JAN-DEC) ) . Sheet 1 has (Employee Name , loan , loan date ,loan bal amt , EMI ) . Sheets 2-13 have loan columns in them which when edited are reflected in main sheet and bal loan amt is updated. I want the rows in sheet 2 to sheet 13 to be filled with color and font to be bold and italic IF the sheet name matches the loan month (date) and if any balance is pending . I also want a msg to appear if a cell in loan column is selected.

    I dont know how to explain it clearly.

    Any other ideas are welcomed . I basically want to data entry guy to know if there is any pending loan for an employee.

    For Example

    EXAMPLE 1 :- If employee C has taken loan (50000) in jan then highlight the row with his name in sheets 2 to 13 untill loan is cleared . (EMI may vary depending on user entry). If loan is cleared in aug then stop highlight in sheet sept to dec.

    EXAMPLE 2 :- If employee F has taken loan (80000) in Apr then highlight the row with his name in sheets 5 to 13 untill loan is cleared . (EMI may vary depending on user entry).
    Attached Files Attached Files
    Last edited by thebeastslayer; 03-07-2020 at 03:13 AM.

  2. #2
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016
    Posts
    761

    Re: Changing FONT and Fill color based on Multiple Criteria

    Why don't you do this with conditionial formatting,
    lin in Cell F4 in "JAN", and its column
    Please Login or Register  to view this content.
    or in F8 in "MAR" and in the same column
    Please Login or Register  to view this content.
    and so on in the whole spreadsheet.
    B/R
    Erwin
    Attached Images Attached Images
    I started learning VBA because I was lazy ...
    Still developing.... being more lazy...

+ 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. Cell Fill Color based on multiple criteria
    By Mr Teafortwo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2014, 02:00 PM
  2. [SOLVED] Changing font color based on date value in another cell
    By winwall in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2014, 10:28 AM
  3. [SOLVED] Changing fill color of shapes based on changing cell value
    By Stefan1983 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-25-2012, 10:33 AM
  4. [SOLVED] changing row font color based on 3 criteria
    By ariel20029 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-28-2012, 02:15 PM
  5. VBA-Fill color based on multiple criteria
    By kimmie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2011, 05:46 PM
  6. Changing font color based on calculation result.
    By pawnraider in forum Excel General
    Replies: 1
    Last Post: 07-17-2010, 10:23 AM
  7. Changing font color based on change from previous value
    By dgtvr in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-18-2008, 04:25 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