Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: Format Color Of Cell Based On Number Of Characters

  1. #1
    Join Date
    28th May 2008
    Posts
    14

    Format Color Of Cell Based On Number Of Characters

    Is it possible to base conditional formatting on text length?

    I want to highlight any cell in a column where there is an entry more than 3 characters long. The values entered into this column will always be one of the following layouts:

    KD ie 2 letters
    KNH ie 3 letters
    KD/KNH (10%) ie a combination of 2 or 3 letters, followed by a forward slash, followed by 2 or 3 letters, followed by a percentage in brackets

    Basically, the column will usually have 2 or 3 letters entered in each cell, but I want my attention to be drawn to a cell if there is going to be more than 3 characters in it.

    many thanks

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    20th February 2006
    Location
    London, UK
    Posts
    2,888

    Re: Conditional Formatting Based On Number Of Characters In A Cell

    Use Formula Is: =LEN(A1)>3

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Format Cell Color Based On Text
    By CintasCharleston in forum EXCEL HELP
    Replies: 5
    Last Post: June 24th, 2008, 06:13
  2. Format Cell Number Based On Value
    By GLT7700 in forum EXCEL HELP
    Replies: 3
    Last Post: February 20th, 2008, 10:24
  3. Replies: 5
    Last Post: January 10th, 2008, 01:30
  4. Format Cells Color Based On 1 Cell
    By frac in forum EXCEL HELP
    Replies: 3
    Last Post: November 24th, 2007, 04:48
  5. Number Format Cell Based on Value
    By paulk1986 in forum EXCEL HELP
    Replies: 1
    Last Post: December 23rd, 2006, 10:47

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
  •  
porno