+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting without changing current formats

  1. #1
    Forum Contributor
    Join Date
    01-16-2009
    Location
    Ill.
    MS-Off Ver
    Excel 2010
    Posts
    190

    Conditional Formatting without changing current formats

    Hello - - I have a file that I would like to apply some conditional formating to but when I do, it removes any other formats. I've dummied up a file and attached it. You'll see that colummn F is Blue and M is yellow. what I want to do is BOLD the row when the word 'Jeff' is found in column B, so in this example A8 to N8 would be BOLD, I need to have the blue and yellow remain. When I copy my conditional format through the sheet, the blue and yellow shade goes away. I'll have over 50 of sheets like this one and 'Jeff' will appear in different rows. I'd rather not use VBA so I was thinking there might be away to do this with conditional formatting...thanks to all you Excel Gurus!!!!
    Attached Files Attached Files
    Last edited by Ironman; 04-15-2011 at 05:31 PM. Reason: Shg - solved this one for me

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Conditional Formatting without changing current formats

    Clear all conditional formatting on the sheet.

    Select A7:N26, Conditional formatting, formula is, =$B7="Jeff"

    Set font style to bold.
    Last edited by shg; 04-15-2011 at 06:21 PM. Reason: corrected cell reference
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    01-16-2009
    Location
    Ill.
    MS-Off Ver
    Excel 2010
    Posts
    190

    Re: Conditional Formatting without changing current formats

    Thanks Shg - - I'll mark this one solved...! I did have to modify your formula to reference b7 rather than b8. Once I did that it seems to be working fine. Thanks again!

+ 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