+ Reply to Thread
Results 1 to 10 of 10

Need Help with Conditional Formatting Hghlight in Excel

  1. #1
    Forum Contributor
    Join Date
    12-30-2014
    Location
    Saudi Arabia
    MS-Off Ver
    2013
    Posts
    111

    Need Help with Conditional Formatting Hghlight in Excel

    Dear Excel forum member's

    I want to higlight wiith conditionl farmete when i enter bill paying amount need to highlight status cell PAID or DUE ( for example i paid may-2019 amout ) same like next month when paid need to highligt cell

    Thanks

    Data Sheet Attached

    Utility Bill Pay Check List.xlsx

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,704

    Re: Need Help with Conditional Formatting Hghlight in Excel

    Capture.JPG See attached.
    Last edited by alansidman; 05-27-2019 at 08:14 PM.

  3. #3
    Forum Contributor
    Join Date
    12-30-2014
    Location
    Saudi Arabia
    MS-Off Ver
    2013
    Posts
    111

    Re: Need Help with Conditional Formatting Hghlight in Excel

    Quote Originally Posted by alansidman View Post
    Attachment 626139 See attached.
    invalid attachment link not oppen

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,704

    Re: Need Help with Conditional Formatting Hghlight in Excel

    Tried again. Seems to work this time. Thanks for letting me know.

  5. #5
    Forum Contributor
    Join Date
    12-30-2014
    Location
    Saudi Arabia
    MS-Off Ver
    2013
    Posts
    111

    Re: Need Help with Conditional Formatting Hghlight in Excel

    Quote Originally Posted by alansidman View Post
    Tried again. Seems to work this time. Thanks for letting me know.
    Thanks i haven't understad how to insert farmula could you please you can insert farmula in excel sheet then re-attached.

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,704

    Re: Need Help with Conditional Formatting Hghlight in Excel

    Attached as requested.

    Also a tutorial from Google Search https://support.office.com/en-us/art...b-f1951ff89d7f
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    12-30-2014
    Location
    Saudi Arabia
    MS-Off Ver
    2013
    Posts
    111

    Re: Need Help with Conditional Formatting Hghlight in Excel

    Quote Originally Posted by alansidman View Post
    Attached as requested.

    Also a tutorial from Google Search https://support.office.com/en-us/art...b-f1951ff89d7f
    Thanks i have tryed but there is no funcion PAID,DUE i have enter amout also help me please

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,704

    Re: Need Help with Conditional Formatting Hghlight in Excel

    Thanks i have tryed but there is no funcion PAID,DUE i have enter amout also help me please
    I have no idea what you are saying here. It makes no sense to me. The tutorial is very clear on how to do conditional formatting.

  9. #9
    Forum Contributor
    Join Date
    12-30-2014
    Location
    Saudi Arabia
    MS-Off Ver
    2013
    Posts
    111

    Re: Need Help with Conditional Formatting Hghlight in Excel

    Quote Originally Posted by alansidman View Post
    I have no idea what you are saying here. It makes no sense to me. The tutorial is very clear on how to do conditional formatting.
    sorry for disturb you what i mean to say if add amount month of may in cell no (K8) then cell no (S8) need to hight PAID
    same like cell no (K10) there is no amount it meant DUE this one aslo need to highlight ( if i add amout highlit to paid if i no add amout that aslo hight lidt due)

  10. #10
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,112

    Re: Need Help with Conditional Formatting Hghlight in Excel

    named ranges:
    Interval ='SAUDI ELECTRICITY'!$R$4
    PaidAmts =OFFSET('SAUDI ELECTRICITY'!$E$5,0,1,COUNTA('SAUDI ELECTRICITY'!$E:$E),MATCH("STATUS",'SAUDI ELECTRICITY'!$5:$5)-5)

    formula in R6..Rn:
    Please Login or Register  to view this content.
    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

    For months in row five, Use mm/01/yyyy formatted as "MMMM"
    Your worksheet has too many unused rows and columns in the data field - bad idea
    Attached Files Attached Files
    Ben Van Johnson

+ 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] Override conditional formatting (in general, without changing the conditional formatting)
    By Stormin' in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2017, 07:15 AM
  2. conditional formatting in excel for HH:MM
    By Hunnymehra in forum Excel General
    Replies: 1
    Last Post: 02-01-2017, 02:22 PM
  3. Replies: 1
    Last Post: 12-08-2016, 03:14 PM
  4. Conditional Formating to compare 2 dates and hghlight
    By rizmomin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-19-2014, 12:01 AM
  5. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  6. Delete Conditional Formatting conditions but keep cell formatting - Excel 2010
    By tetreama in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-09-2012, 08:28 PM
  7. Replies: 8
    Last Post: 04-24-2010, 03:06 AM

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