+ Reply to Thread
Results 1 to 5 of 5

Conditional format formula to highlight cells with a percentage

Hybrid View

  1. #1
    Registered User
    Join Date
    07-21-2013
    Location
    london england
    MS-Off Ver
    Microsoft Office 365
    Posts
    98

    Conditional format formula to highlight cells with a percentage

    i have set up conditioning formatting to highlight cells in a row yellow if they are 3 or under. I have also added another rule to colour the cells white if blank so it will only colour cells within the table. However, the columns with the weekly percentages are being affected as they are being read as below 4. Can you please give me a formula to recognise a cell with a percentage format and to colour it white thus removing the yellow highlight?
    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,775

    Re: Conditional format formula to highlight cells with a percentage

    Use
    Formula: copy to clipboard
    =AND(B3<>"",B3<4)
    with the applies to range as
    =$B$3:$H$5,$J$3:$P$5

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,080

    Re: Conditional format formula to highlight cells with a percentage

    For the yellow ones
    Remove all the yellow formulas

    Select the entire range

    =AND(B3<4,COLUMN()<>9,COLUMN()<>17)
    format as yellow
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Registered User
    Join Date
    07-21-2013
    Location
    london england
    MS-Off Ver
    Microsoft Office 365
    Posts
    98

    Re: Conditional format formula to highlight cells with a percentage

    thanks for the responses. sorry, i forgot to mention that the weekly columns will be ongoing. That's why I am formatting the entire rows. will these formulas still work?

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,775

    Re: Conditional format formula to highlight cells with a percentage

    In that case select B3 to whatever & use
    Formula: copy to clipboard
    =AND(B3<>"",B3<4,B$2<>"%")

+ 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. Conditional Formatting to format cells to Percentage
    By mikehk in forum Excel General
    Replies: 5
    Last Post: 03-15-2019, 09:46 PM
  2. Help with conditional format to highlight partial text cells
    By ivpush33 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-07-2016, 01:40 PM
  3. Replies: 5
    Last Post: 09-05-2013, 08:59 AM
  4. Replies: 6
    Last Post: 06-29-2013, 03:56 PM
  5. Highlight Unlike Cells (Conditional Format)?
    By stuffleb in forum Excel General
    Replies: 3
    Last Post: 09-21-2011, 07:35 PM
  6. Conditional Format formula to Cells highlight.
    By johncena in forum Excel General
    Replies: 4
    Last Post: 03-23-2010, 04:09 AM
  7. [SOLVED] Conditional Format-highlight the cells in column
    By Steph in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-15-2006, 12:24 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