+ Reply to Thread
Results 1 to 7 of 7

Conditional Formatting - General prob & how to change colour of a cell if text is in it

  1. 05-19-2012, 05:31 AM #1
    3smees23
    3smees23 is offline
    Forum Contributor
    Join Date
    12-30-2008
    Location
    Woking, England
    MS-Off Ver
    Excel 2007
    Posts
    197

    Conditional Formatting - General prob & how to change colour of a cell if text is in it

    Hi,

    I have two problems with conditional formatting.

    1) I'm trying to change the colour of text in L43 to red if any cells in P33:P41 go below a figure of 80. Yet the below is not working.

    Please Login or Register  to view this content.
    2) I need to change the colour of the green box (L46:O54) to red if there is text present in it. I have looked on the net but can't find the appropriate function.

    Any help would be appreciated.

    Many thanks

    Sam
    Attached Files Attached Files
    Last edited by 3smees23; 05-19-2012 at 06:51 AM.
    Reply With QuoteRegister To Reply
  2. 05-19-2012, 05:43 AM #2
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Conditional Formatting - General prob & how to change colour of a cell if text is in i

    Hi Sam

    For the first question, i use a lot of IF(OR function.

    For the second, =ISTEXT(L46)

    Is this, works for you?
    Attached Files Attached Files
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  3. 05-19-2012, 05:55 AM #3
    Marcol
    Marcol is offline
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Conditional Formatting - General prob & how to change colour of a cell if text is in i

    For 1/. try ...
    Please Login or Register  to view this content.
    And for 2/.
    Please Login or Register  to view this content.
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
    Reply With QuoteRegister To Reply
  4. 05-19-2012, 06:19 AM #4
    3smees23
    3smees23 is offline
    Forum Contributor
    Join Date
    12-30-2008
    Location
    Woking, England
    MS-Off Ver
    Excel 2007
    Posts
    197

    Re: Conditional Formatting - General prob & how to change colour of a cell if text is in i

    Hi Fotis, Marcol

    I tried yours Marcol. The first one worked perfectly. With the second is it possible to turn that whole green section red when there is text present?

    Cheers

    Sam
    Reply With QuoteRegister To Reply
  5. 05-19-2012, 06:30 AM #5
    Marcol
    Marcol is offline
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Conditional Formatting - General prob & how to change colour of a cell if text is in i

    Try this ...
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 05-19-2012, 06:50 AM #6
    3smees23
    3smees23 is offline
    Forum Contributor
    Join Date
    12-30-2008
    Location
    Woking, England
    MS-Off Ver
    Excel 2007
    Posts
    197

    Re: Conditional Formatting - General prob & how to change colour of a cell if text is in i

    Great!! Thanks for the help bud.

    Have a good weekend

    Sam
    Reply With QuoteRegister To Reply
  7. 05-19-2012, 06:51 AM #7
    Marcol
    Marcol is offline
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Conditional Formatting - General prob & how to change colour of a cell if text is in i

    On behalf of all, happy to have helped.
    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)

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