+ Reply to Thread
Results 1 to 8 of 8

Conditional format a between range using -use a formula to determine which cells to format

  1. #1
    Registered User
    Join Date
    01-12-2015
    Location
    Manchester
    MS-Off Ver
    2007
    Posts
    17

    Conditional format a between range using -use a formula to determine which cells to format

    Hi,

    I want to highlight a cell to let me know if the value is between 75% and 99% using "use a formula to determine which cells to format", so then I can copy the format to various cells without having to manually enter them.

    I have attached a spreadsheet as an example. I would like it to show the following -

    Green - 100% and above (=a10*100/a6>=100)
    Amber - 75% - 99%
    Red - Below 75% (100*a10/a6<=75)

    Thank you!
    Attached Files Attached Files

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,134

    Re: Conditional format a between range using -use a formula to determine which cells to fo

    Hi,

    I have updated the Conditional formatting in the attached file cell C10. Please see if it suits your requirement.

  3. #3
    Registered User
    Join Date
    01-12-2015
    Location
    Manchester
    MS-Off Ver
    2007
    Posts
    17

    Re: Conditional format a between range using -use a formula to determine which cells to fo

    That's great but is there any where I can include the sum in the conditional format rather than use another cell?

    Thank you

  4. #4
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,134

    Re: Conditional format a between range using -use a formula to determine which cells to fo

    You can just copy the cell formatting on C10 by using "Format Painter" and paste it anywhere else on the sheet.

  5. #5
    Registered User
    Join Date
    01-12-2015
    Location
    Manchester
    MS-Off Ver
    2007
    Posts
    17

    Re: Conditional format a between range using -use a formula to determine which cells to fo

    Apologies, is there any way I can include the formula in C10 into =and(c10>=0.75,c10<1) ?

    Thank you

  6. #6
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,134

    Re: Conditional format a between range using -use a formula to determine which cells to fo

    Yes, you can. If you want to modify the Conditional Formatting, you can do so by clicking on Conditional Formatting -> Manage Rules...

  7. #7
    Registered User
    Join Date
    01-12-2015
    Location
    Manchester
    MS-Off Ver
    2007
    Posts
    17

    Re: Conditional format a between range using -use a formula to determine which cells to fo

    Would you pleas be kind enough to type out the full formula?

    Thank you

  8. #8
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,134

    Re: Conditional format a between range using -use a formula to determine which cells to fo

    Sure..

    For GREEN: =$C$10>=1
    For AMBER: =AND($C$10>=0.75,$C$10<1)
    For RED: =$C$10<0.75
    Attached Images Attached Images

+ 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. [SOLVED] Conditional Formatting to Use a formula to determine which cells to format
    By kenadams378 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-16-2013, 10:29 AM
  2. Replies: 7
    Last Post: 02-20-2013, 06:34 PM
  3. Replies: 1
    Last Post: 10-12-2012, 08:28 AM
  4. Replies: 3
    Last Post: 08-04-2012, 07:22 PM
  5. Use a formula to determine which cells to format?
    By jonvanwyk in forum Excel General
    Replies: 4
    Last Post: 06-04-2012, 11:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1