| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting
Hi,
Is there a way to set up a conditional formatting between texts? Here is what Id like to be: Text Text Text - This will be color Credit Card - this will be color Credit Card Discover Card - this will be color Discover Car Any suggestions would be appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting
With your data in Column A;
--Select Column A or the range. A1 mentioned in this example is the first cell of the range. =COUNTIF(A$1:A1,A1)=1 If this post helps click Yes --------------- Jacob Skaria "momotaro" wrote: Hi, Is there a way to set up a conditional formatting between texts? Here is what Id like to be: Text Text Text - This will be color Credit Card - this will be color Credit Card Discover Card - this will be color Discover Car Any suggestions would be appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting
Do you mean a conditional format will be made if the contents are the same as
the criteria (Text, Credit Card, Discover Card, etc.) or randomly done? momotaro wrote: Hi, Is there a way to set up a conditional formatting between texts? Here is what Id like to be: Text Text Text - This will be color Credit Card - this will be color Credit Card Discover Card - this will be color Discover Car Any suggestions would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
| 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 | |||
Linear Mode
