+ Reply to Thread
Results 1 to 9 of 9

Need a lillte help with Conditional Formatting

  1. #1
    Forum Contributor
    Join Date
    02-02-2013
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2010
    Posts
    152

    Need a lillte help with Conditional Formatting

    I tried to use this formula "=IF($E$11:$E$207,IsBold)" to highlight the bold numbers, but I am getting nothing. Any help on this would be greatly appreciated.


    Roco

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,359

    Re: Need a lillte help with Conditional Formatting

    it won't work
    please upload your wb.

  3. #3
    Forum Contributor
    Join Date
    02-02-2013
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2010
    Posts
    152

    Re: Need a lillte help with Conditional Formatting

    Please see the attached file. Thanks for taking a look.

    Roco
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,912

    Re: Need a lillte help with Conditional Formatting

    Try is this way
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  5. #5
    Forum Contributor
    Join Date
    02-02-2013
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2010
    Posts
    152

    Re: Need a lillte help with Conditional Formatting

    It worked until I hit my refresh button and then it removed it out of conditional formatting. Looks like I would need a macros? I appreciate you looking at it, can you still help out with a macros?

    Roco

  6. #6
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,912

    Re: Need a lillte help with Conditional Formatting

    Sorry but I can't help you with macro's

  7. #7
    Forum Contributor
    Join Date
    02-02-2013
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2010
    Posts
    152

    Re: Need a lillte help with Conditional Formatting

    Thanks for taking a look at this. I appreciate it.

  8. #8
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,874

    Re: Need a lillte help with Conditional Formatting

    If nothing else, you can select all of your "total" rows at once by clicking on one of them (when you hover your mouse on the left side and it turns into a right arrow) then change the fill color.

    This will, however, change the entire table row that the number is in instead of just the cell with the number.

  9. #9
    Forum Contributor
    Join Date
    02-02-2013
    Location
    Jacksonville, Florida
    MS-Off Ver
    Excel 2010
    Posts
    152

    Re: Need a lillte help with Conditional Formatting

    Great tip...had no idea that would work. But I did post in macro's also, because this will be used by others that have less experience than I. Thanks

+ 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. Replies: 1
    Last Post: 12-08-2016, 03:14 PM
  2. Replies: 2
    Last Post: 10-03-2016, 08:35 AM
  3. Conditional Formatting Removing Previous Conditional Formatting?
    By CravingGod in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2016, 01:02 PM
  4. Replies: 6
    Last Post: 01-08-2016, 06:44 PM
  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. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  7. Replies: 3
    Last Post: 05-15-2012, 04:13 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