|
conditional formatting
HI,
If I want more then 3 text values to be yellow for instance... Is that possible. Because I can only add three.... but I think maybe its possible to add more than one criterium per box... If I want "V" and "X" and "C" to become yellow... Can I put that in one box? Something like.. ="V";"X";"C" ... Hope someone can help. Thanks in advace |
conditional formatting
Select ColumnA. For Condition1Select 'Formula Is' and enter the below formula
=OR(A1="V",A1="X",A1="C") Alternatively; if you have more words..you can create a named range and try the below formula =COUNTIF(keywords,A1)0 If this post helps click Yes --------------- Jacob Skaria "mariekek5" wrote: HI, If I want more then 3 text values to be yellow for instance... Is that possible. Because I can only add three.... but I think maybe its possible to add more than one criterium per box... If I want "V" and "X" and "C" to become yellow... Can I put that in one box? Something like.. ="V";"X";"C" ... Hope someone can help. Thanks in advace |
conditional formatting
actually, I want it in a bogger area....not just one column....
Is it also possible then?! "Jacob Skaria" wrote: Select ColumnA. For Condition1Select 'Formula Is' and enter the below formula =OR(A1="V",A1="X",A1="C") Alternatively; if you have more words..you can create a named range and try the below formula =COUNTIF(keywords,A1)0 If this post helps click Yes --------------- Jacob Skaria "mariekek5" wrote: HI, If I want more then 3 text values to be yellow for instance... Is that possible. Because I can only add three.... but I think maybe its possible to add more than one criterium per box... If I want "V" and "X" and "C" to become yellow... Can I put that in one box? Something like.. ="V";"X";"C" ... Hope someone can help. Thanks in advace |
conditional formatting
Thats'fine. Select the area you would like to apply the formatting.
Say if the range is C10:H30 refer the starting range in the formula like =OR(C10="V",C10="X",C10="C") If this post helps click Yes --------------- Jacob Skaria "mariekek5" wrote: actually, I want it in a bogger area....not just one column.... Is it also possible then?! "Jacob Skaria" wrote: Select ColumnA. For Condition1Select 'Formula Is' and enter the below formula =OR(A1="V",A1="X",A1="C") Alternatively; if you have more words..you can create a named range and try the below formula =COUNTIF(keywords,A1)0 If this post helps click Yes --------------- Jacob Skaria "mariekek5" wrote: HI, If I want more then 3 text values to be yellow for instance... Is that possible. Because I can only add three.... but I think maybe its possible to add more than one criterium per box... If I want "V" and "X" and "C" to become yellow... Can I put that in one box? Something like.. ="V";"X";"C" ... Hope someone can help. Thanks in advace |
conditional formatting
Its strange, because when I do exactly what you tell me....the cells I want
to be yellow stay normal, whereas the cells I want to be normal, become yellow.... "Jacob Skaria" wrote: Thats'fine. Select the area you would like to apply the formatting. Say if the range is C10:H30 refer the starting range in the formula like =OR(C10="V",C10="X",C10="C") If this post helps click Yes --------------- Jacob Skaria "mariekek5" wrote: actually, I want it in a bogger area....not just one column.... Is it also possible then?! "Jacob Skaria" wrote: Select ColumnA. For Condition1Select 'Formula Is' and enter the below formula =OR(A1="V",A1="X",A1="C") Alternatively; if you have more words..you can create a named range and try the below formula =COUNTIF(keywords,A1)0 If this post helps click Yes --------------- Jacob Skaria "mariekek5" wrote: HI, If I want more then 3 text values to be yellow for instance... Is that possible. Because I can only add three.... but I think maybe its possible to add more than one criterium per box... If I want "V" and "X" and "C" to become yellow... Can I put that in one box? Something like.. ="V";"X";"C" ... Hope someone can help. Thanks in advace |
conditional formatting
It works perfectly indeed.
(oblviously I did something wrong before ) "Jacob Skaria" wrote: Thats'fine. Select the area you would like to apply the formatting. Say if the range is C10:H30 refer the starting range in the formula like =OR(C10="V",C10="X",C10="C") If this post helps click Yes --------------- Jacob Skaria "mariekek5" wrote: actually, I want it in a bogger area....not just one column.... Is it also possible then?! "Jacob Skaria" wrote: Select ColumnA. For Condition1Select 'Formula Is' and enter the below formula =OR(A1="V",A1="X",A1="C") Alternatively; if you have more words..you can create a named range and try the below formula =COUNTIF(keywords,A1)0 If this post helps click Yes --------------- Jacob Skaria "mariekek5" wrote: HI, If I want more then 3 text values to be yellow for instance... Is that possible. Because I can only add three.... but I think maybe its possible to add more than one criterium per box... If I want "V" and "X" and "C" to become yellow... Can I put that in one box? Something like.. ="V";"X";"C" ... Hope someone can help. Thanks in advace |
| All times are GMT +1. The time now is 07:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com