Forum Discussion
Solved
Conditional formatting background colour for 'if text contains'
Hello! I need some help with coniditional formatting. I have checked through all other posts on the topic before I have posted this but think my query may be slightly different. I have a list of ...
Hi thinkvisual
You may have a look at FIND function.
Column = IF ( FIND ( "video", [URL], 1, -1 ) > 0, 1, // If find 'video',the column get 1 IF ( FIND ( "photo", [URL], 1, 0 ) > 0, 2, 3 ) ) // If find 'photo',get 2,otherwise get 3Regards,
Hi thinkvisual
You may have a look at FIND function.
Column =
IF (
FIND ( "video", [URL], 1, -1 ) > 0,
1, // If find 'video',the column get 1
IF ( FIND ( "photo", [URL], 1, 0 ) > 0, 2, 3 )
) // If find 'photo',get 2,otherwise get 3
Regards,
Thank you so much for your help, much appreciated.
David