Results 1 to 5 of 5

Conditional format formula to highlight cells with a percentage

Threaded 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

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. 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