Conditional formatting - Indirect function with multiple conditions

[suneeshpillai]

Hi,

Is anyone can help me to resolve the below issue I'm facing in Conditional formatting :

I am looking for solution to resolve the Conditional formatting - Indirect function with multiple conditions.

Wrote the condition as mentioned below, but it's not working. If anyone can help me to correct it, it will be helpful to me.

=INDIRECT("L"&ROW())=("Meeting Scheduled", "Meeting Held", "---","---")

Looking forward for the response.

Regards

Suneesh

[AliGW]

What is it supposed to do?

[FDibbins]

That does not look like CF formula to me, more like just a regular cell function. I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[Phuocam]

Try this:

=SEARCH(","&INDIRECT("L"&ROW())&",",",Meeting Scheduled,Meeting Held,---,")

[suneeshpillai]

It's not working my friend.

[Phuocam]

Try change "," to ";"

[AliGW]

With A3 selected, set three rules:

=$D3="Planned"

=OR($D3="Scheduled",$D3="Budgeted")

=$D3="Visited"

Applies to for all three: =$A$3:$D$12

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.