Or; and condition

**kuzna26** · 10-23-2018, 10:37 AM

Hi guys please I have a column, and I would like to have one of this cell C3-C7 is highlighted in green if there is one of these letters;

 EWS
 EVW

and on one of this cell D3-D7 to count 1 if either one of C3-C7 filled with
 EWS
 EVW

Thanks

**63falcondude** · 10-23-2018, 10:52 AM

I would like to have one of this cell C3-C7 is highlighted in green if there is one of these letters...

Highlight C3:C7 > Conditional Formatting > New Rule > Use a formula
=OR(C3="EWS",C3="EVW")
Format: Fill color of your choice > OK > OK

and on one of this cell D3-D7 to count 1 if either one of C3-C7 filled with...

D3 =--(OR(C3="EWS",C3="EVW"))
Drag down through D7.

**than_gold** · 10-23-2018, 10:54 AM

You could try this out:
Then enter this formula: =SUM(COUNTIF(A2,"*"&Mylist&"*")) (A2 is the first cell of the range you want to highlight, Mylist is the range name you have created in step 1) into the Format values where this formula is true text box;

Pls check here for further input:https://www.extendoffice.com/documen...ple-words.html

Or; and condition

LinkBack

Thread Tools

Rate This Thread

Display

Or; and condition

Re: Or; and condition

Re: Or; and condition

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Rotate List of names bottom to top Repeat without condition with option to set a condition

[SOLVED] condition fails. If condition deletes main worksheet

Play sound when condition is met, but not continuously while condition remains satisfied?

Condition formatting of multiple condition formatted cells

[SOLVED] IF the condition of gender is met AND the condition of age is met subtract this number

[SOLVED] Help for if condition formula result only either hit or miss from mulitple condition

multi condition format? lookup and date condition valid for.

Bookmarks

Bookmarks

Posting Permissions