Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting based on character count
I need to conditionally format the cell to be highlighted if the total
character count (=len) of the cell is greater than 50. I am close. I can do it in multiple steps. I would like to combine it in a single formula if possible. Can anyone help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting based on character count
Select the cell(s) that you want this to apply to (suppose A1 is the
active cell if you have more than one highlighted), then in the Conditional Format dialogue you need to select Formula Is rather than Cell Value Is in the first box, and enter this formula: =LEN(A1)50 Then click on the Format button, choose the Patterns tab (for background colour) then click on the colour you want to show. Click OK twice to exit the dialogue box. Hope this helps. Pete On Sep 3, 12:17*am, Rhonda H. <Rhonda wrote: I need to conditionally format the cell to be highlighted if the total character count (=len) of the cell is greater than 50. *I am close. I can do it in multiple steps. I would like to combine it in a single formula if possible. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Based of Cells Based on Data Entry in anoth | Excel Discussion (Misc queries) | |||
Conditional Formatting Based on vlookup Value | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting Based on If and Or | Excel Discussion (Misc queries) |