+ Reply to Thread
Results 1 to 4 of 4

Conditional formatting for a range

Hybrid View

  1. 07-27-2015, 09:48 PM #1
    bryden2008
    bryden2008 is offline
    Registered User
    Join Date
    07-15-2015
    Location
    new hampshire
    MS-Off Ver
    Office 2010
    Posts
    83

    Conditional formatting for a range

    In c33, i want it to turn red if the letter c is found as a wildcard in range w10:w27.
    How?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-27-2015, 09:55 PM #2
    quekbc
    quekbc is offline
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: Conditional formatting for a range

    In C33, set a conditional formatting based on this formula

    Formula: copy to clipboard 
    =COUNTIF(W10:W27,"*C*")<>0
    Reply With QuoteRegister To Reply
  3. 07-27-2015, 10:22 PM #3
    bryden2008
    bryden2008 is offline
    Registered User
    Join Date
    07-15-2015
    Location
    new hampshire
    MS-Off Ver
    Office 2010
    Posts
    83

    Re: Conditional formatting for a range

    Thank you that worked!
    Reply With QuoteRegister To Reply
  4. 07-27-2015, 10:38 PM #4
    quekbc
    quekbc is offline
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: Conditional formatting for a range

    That's great to hear and thanks for the rep, bryden2008.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Conditional formatting one range containing text from another range
    By thedeakster in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-01-2013, 05:00 PM
  2. Conditional formatting large range of cells, based on percentage of previous cell in range
    By brianfromla in forum Excel General
    Replies: 3
    Last Post: 08-13-2013, 09:44 AM
  3. Conditional Formatting via VBA: Change formatting in range based on value of each cell
    By ralphjmedia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2013, 10:37 AM
  4. [SOLVED] Applying Conditional Formatting to a Range in VBA (range is set by variables)
    By JungleJme in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-12-2013, 08:32 AM
  5. Conditional Formatting - Grey Out and Lock A range based on a cell value in that range
    By Excelgnome in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-14-2012, 07:31 PM
  6. Conditional Formatting In a Range
    By mikesteven in forum Excel General
    Replies: 1
    Last Post: 07-13-2006, 04:40 PM
  7. [SOLVED] Conditional Formatting (How to format a range depending on another range)
    By Josh Rogers in forum Excel General
    Replies: 2
    Last Post: 10-06-2005, 03:05 PM
  8. [SOLVED] Conditional formatting-Can I do a conditional formatting on a range
    By ESREI in forum Excel General
    Replies: 3
    Last Post: 03-02-2005, 08: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1