Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Hi,
i have a range of values that are either blank, are one of the values from the list below, or have an "X" in each cell. If I only want to affect the values that match the list, so that ones that are an "X" or blank are not affected, how could I do so? 1 2 3 4a 4b 4c 5a 5b 5c 6a 6b 6c 7 Thanks, Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
One way:
Formula is =AND(A1<"",NOT(ISERR(FIND(A1,"1234a4b4c5a5b5c6a6b 6c7")))) In article , prana1 wrote: Hi, i have a range of values that are either blank, are one of the values from the list below, or have an "X" in each cell. If I only want to affect the values that match the list, so that ones that are an "X" or blank are not affected, how could I do so? 1 2 3 4a 4b 4c 5a 5b 5c 6a 6b 6c 7 Thanks, Eric |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Select the range to be conditionally formatted. In this example, assume the
range begins in A1. Select Format Conditional Formatting. Instead of 'Cell Value Is', select 'Formula Is' and enter this formula: =AND(A1<"X",LEN(A1)0) Then apply the formatting desired. Hope this helps, Hutch "prana1" wrote: Hi, i have a range of values that are either blank, are one of the values from the list below, or have an "X" in each cell. If I only want to affect the values that match the list, so that ones that are an "X" or blank are not affected, how could I do so? 1 2 3 4a 4b 4c 5a 5b 5c 6a 6b 6c 7 Thanks, Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Conditional Formatting | Setting up and Configuration of Excel |