Forum Discussion
IF statement
Hi Everyone ,
Happy to E meet you all ..!!
Please help me out with this "Number of shows are “n” which have been split commonly between “m” variable campaigns , if any “m” campaigns has shared common with “n” shows need indication on launch date (column) .
Can you guys please help me to write a “IF statement “ . on excel
Attached is just an example :-
=SUMPRODUCT(($C$4:$C$9=C4)*($D$4:$D$9<>D4))For the data layout of the example you can try this rule for conditional formatting if you want to highlight the date for a campaign that was promoted at more than 1 show.
OliverScheurich Thank you so much for the reply . But this is not helping .
Conditional formatting in other cells
Highlight the cell or range you want Choose
“Home > Conditional Formatting < New Rule” Select “
Use a formula to determine which cells to format”
Click in the cell under “Format values for which these values are true”
Enter =B2=”” Click on “Format” and select the “Fill” tab, choose a fill color
Enter OK...and ready!
Additional information/link:
Use conditional formatting to highlight information
Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values.
I know I don't know anything (Socrates)
- Hi Nikolini DE,
Thank you for the reply . But this is not giving the result .If I may recommend, please attach a file and explain step by step what you intend to do.
It could be that some "like me" 🙂 🙂 can't understand it.
Or use a picture (please with column and line numbers) to explain step by step what you intend to do.
Please keep in mind that only you can see your digital environment, so it would also be an advantage if you would provide information on the Excel version, operating system and storage medium.
Thank you for your patience and understanding
