+ Reply to Thread
Results 1 to 10 of 10

Conditional Formating

  1. #1
    Registered User
    Join Date
    01-24-2013
    Location
    Las Vegas
    MS-Off Ver
    Excel 2013
    Posts
    17

    Unhappy Conditional Formating

    I have an excel spread sheet that I would like to use conditional formatting. On my Expenditures tab I want to auto highlight my automatic bills, on my data tab, I have the listed bills that auto pay. Can you help me with how to set this up please?
    Attached Files Attached Files

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Conditional Formating

    You can use a formula like this one:
    Please Login or Register  to view this content.
    You have tochose which color you want them to be.
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

  3. #3
    Registered User
    Join Date
    01-24-2013
    Location
    Las Vegas
    MS-Off Ver
    Excel 2013
    Posts
    17

    Re: Conditional Formating

    I tried putting that into the conditional formatting area and no luck...any ideas?

  4. #4
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Conditional Formating

    I did it for you in the attached file.
    It could be the copy and paste of the formula that created some problem. I had to change the cell reference to I1 because it was copied as I10469???.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-24-2013
    Location
    Las Vegas
    MS-Off Ver
    Excel 2013
    Posts
    17

    Re: Conditional Formating

    Awesome thanks, one last question...is there any why to have the fill run from the date to the amount....or will it just highlight the single cell?

  6. #6
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Conditional Formating

    All cells in that column will be highlighted if you have one of those expenses in them. You can limit its scope to a specific range if you like.

  7. #7
    Registered User
    Join Date
    01-24-2013
    Location
    Las Vegas
    MS-Off Ver
    Excel 2013
    Posts
    17

    Re: Conditional Formating

    I was wanting to highlight the section or the row based on what one cell says...take a look at the excel doc and you will see what I am talking about. I don't know if it possible or not. But I was hopping to get the date to the amount highlighted....
    Attached Files Attached Files

  8. #8
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Conditional Formating

    Is this what you were looking for?
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    01-24-2013
    Location
    Las Vegas
    MS-Off Ver
    Excel 2013
    Posts
    17

    Re: Conditional Formating

    Sure is, how is that done?

  10. #10
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Conditional Formating

    In the "Conditional formatting rules manager" window, you have the opportunity to specify the range where this rule will be applyied to. In your case, it is from column G to column J.
    You also need to make your formula columns' independant by putting a $ in front of the column letter in your formula. See the $ before the I1 reference in the formula.
    Please Login or Register  to view this content.
    You always write your formula using the first row of your applied range. As here, the conditional formatting is applied to the whole column, so I wrote the formula with I1 in reference.
    It would be much faster to recalculate your worksheet if you limit this conditional formatting to a specific range as in your case it could be only from $G$9 to $J$38. In this case, the formula would have benn written with reference to cell I9 because it is in the first row in the applied to range.
    A bit tricky but by experimenting, you get used to it.
    Regards

+ Reply to Thread

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