Conditional formatting based on if contains a specific symbol

%3CLINGO-SUB%20id%3D%22lingo-sub-2841181%22%20slang%3D%22en-US%22%3EConditional%20formatting%20based%20on%20if%20contains%20a%20specific%20symbol%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2841181%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20creating%20a%20tutor%20master.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esome%20courses%20are%20one%20day%20others%20are%202%20days.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ea%20%3D%20month%3C%2FP%3E%3CP%3Eb%20%3D%20which%20day%20of%20week%3C%2FP%3E%3CP%3Ec%20%3D%20dates%20of%20course%3C%2FP%3E%3CP%3Ed%20%3D%20start%20and%20end%20times%20of%20course%3C%2FP%3E%3CP%3Ef%20%3D%20lead%20tutor%20day%201%3C%2FP%3E%3CP%3Eg%20%3D%20support%20tutor%20day%201%3C%2FP%3E%3CP%3Eh%20%3D%20lead%20tutor%20day%202%3C%2FP%3E%3CP%3Ei%20%3D%20support%20tutor%20day%202%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20its%20a%202%20day%20course%20b%20and%20c%20cells%20for%20that%20row%20will%20contain%20an%20%26amp%3B%20symbol%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eso%20if%20%26amp%3B%20is%20found%20in%20column%20c%20of%20that%20row%20i%20want%20to%20use%20the%20existing%20conditional%20formating%20rules.%20but%20if%20%26amp%3B%20is%20not%20present%20in%20column%20c%20of%20that%20row%20then%20format%20column%20h%20and%20i%20in%20that%20row%20to%20show%20there%20is%20no%20day%202.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20column%20b%20in%20a%20row%20contains%20the%20word%20cancelled%20i%20want%20all%20cells%20on%20that%20row%20column%20b%20-%20q%20to%20have%20a%20specific%20formatting%20to%20indicate%20the%20course%20on%20that%20dates%20is%20cancelled.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehow%20do%20i%20acheive%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2841181%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I am creating a tutor master.

 

some courses are one day others are 2 days.

 

a = month

b = which day of week

c = dates of course

d = start and end times of course

f = lead tutor day 1

g = support tutor day 1

h = lead tutor day 2

i = support tutor day 2

 

if its a 2 day course b and c cells for that row will contain an & symbol

 

so if & is found in column c of that row i want to use the existing conditional formating rules. but if & is not present in column c of that row then format column h and i in that row to show there is no day 2.

 

if column b in a row contains the word cancelled i want all cells on that row column b - q to have a specific formatting to indicate the course on that dates is cancelled.

 

how do i acheive this.

0 Replies