| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting for more than 3 conditions
Hi,
Is there any solution for the following : I have six type of conditions, if any condition is met, cell colour should be yellow. For example, if cell value is any one of the following : DATA1 DATA2 DATA3 DATA4 DATA5 DATA6 All cells containing above should show yellow colour in the file. Please help. Thanks, Jai |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting for more than 3 conditions
formula is
=or(c1="data1",c1="data2",etc) or =or(c1={"data1","data2"}) -- Don Guillett Microsoft MVP Excel SalesAid Software "Jai" wrote in message ... Hi, Is there any solution for the following : I have six type of conditions, if any condition is met, cell colour should be yellow. For example, if cell value is any one of the following : DATA1 DATA2 DATA3 DATA4 DATA5 DATA6 All cells containing above should show yellow colour in the file. Please help. Thanks, Jai |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting for more than 3 conditions
Hi Jai
Use a formula, try =ISNUMBER(SEARCH("Data",A1)) HTH Peter "Jai" wrote: Hi, Is there any solution for the following : I have six type of conditions, if any condition is met, cell colour should be yellow. For example, if cell value is any one of the following : DATA1 DATA2 DATA3 DATA4 DATA5 DATA6 All cells containing above should show yellow colour in the file. Please help. Thanks, Jai |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting for more than 3 conditions
How much you wanna bet that his "data" is not really named "data"?
-- Don Guillett Microsoft MVP Excel SalesAid Software "Billy Liddel" wrote in message ... Hi Jai Use a formula, try =ISNUMBER(SEARCH("Data",A1)) HTH Peter "Jai" wrote: Hi, Is there any solution for the following : I have six type of conditions, if any condition is met, cell colour should be yellow. For example, if cell value is any one of the following : DATA1 DATA2 DATA3 DATA4 DATA5 DATA6 All cells containing above should show yellow colour in the file. Please help. Thanks, Jai |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting - more than 3 conditions | Excel Discussion (Misc queries) | |||
| Conditional formatting - with 2 conditions | Excel Discussion (Misc queries) | |||
| PLEASE HELP: More then 3 conditions on Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting on more than "4" Conditions | Excel Discussion (Misc queries) | |||
| Conditional formatting: I have five conditions, how to do this? | Excel Discussion (Misc queries) | |||
Linear Mode
