Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting using text and exceptions
Hi,
I'd like to color a cell using conditional formatting if there is text in it (sentences etc), but with the exception of single letters (a,b,c,d,etc...). So: A 1 a 2 about The background color of A1 is unaltered. The background color of A2 is changed into red. Thank you! -- Kind regards, Nic |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting using text and exceptions
Hi,
You don't really define what etc is so I've assumed any single letter. Select the column of date and apply this conditional format with the coloue red =AND(ISTEXT(A1),LEN(A1)1) Mike "Nic Daniels" wrote: Hi, I'd like to color a cell using conditional formatting if there is text in it (sentences etc), but with the exception of single letters (a,b,c,d,etc...). So: A 1 a 2 about The background color of A1 is unaltered. The background color of A2 is changed into red. Thank you! -- Kind regards, Nic |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting using text and exceptions
Select the cells from A1 down to wherever, then click on Format |
Conditional Formatting and choose Formula Is rather than Cell Value Is, and enter this formula: =AND(ISTEXT(A1),LEN(A1)1) Then click the Format button, choose the Patterns tab (for background colour) and click on Red. Then OK your way out. The formula will adjust for all the cells in the highlighted block. Hope this helps. Pete On Jul 28, 11:18*am, Nic Daniels wrote: Hi, I'd like to color a cell using conditional formatting if there is text in it (sentences etc), but with the exception of single letters (a,b,c,d,etc...). So: * *A 1 a 2 about The background color of A1 is unaltered. The background color of A2 is changed into red. Thank you! -- Kind regards, Nic |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting using text and exceptions
Give this formula in conditional formatting
=AND(ISTEXT(K133),(LEN(K133)1)) "Nic Daniels" wrote: Hi, I'd like to color a cell using conditional formatting if there is text in it (sentences etc), but with the exception of single letters (a,b,c,d,etc...). So: A 1 a 2 about The background color of A1 is unaltered. The background color of A2 is changed into red. Thank you! -- Kind regards, Nic |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting using text and exceptions
Thank you, all of you!
-- Kind regards, Nic "Nic Daniels" wrote: Hi, I'd like to color a cell using conditional formatting if there is text in it (sentences etc), but with the exception of single letters (a,b,c,d,etc...). So: A 1 a 2 about The background color of A1 is unaltered. The background color of A2 is changed into red. Thank you! -- Kind regards, Nic |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting text | Excel Discussion (Misc queries) | |||
conditional formatting in text box | Excel Discussion (Misc queries) | |||
Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) | |||
Conditional Formatting of Text... | Excel Discussion (Misc queries) |