Conditional Formatting for a range of cells

[TwistedFaith]

Hi I'm trying to use conditional formatting in Excel 2019 to highlight a range of cells one color if they contain a a specific text/s and another color if they don't contain said specific text/s.

example:
If cell in column A contains the text "good" or "evil" or "bad" then highlight cell row from column L to column R GREEN, and if it doesn't contain either of those text then highlight RED

[AliGW]

You will need an OR statement for the GREEN rule:

=OR($A1="good",$A1="evil",$A1="bad)

Applies to: L:R

For RED, maybe this:

=AND($A1<>"good",$A1<>"evil",$A1<>"bad)

Applies to: L:R

[TwistedFaith]

@AliGW thanks that might work but how to I do the applies to part?? I selected the range that I wanted to an went to conditional formatting after that; but when I inputted the formula to use it only highlighted the cells that matched it in the first column of the selected range also I am/need to include basically all cells in the range and the actually range would include column A. So then the range would be from A:R and column A is where I want it to look for the specific texts and highlight the row that does/doesn't contain those text from A:R.

I'm not sure if I'm actually making the above statement clear but I hope you or someone else that can help gets what I'm trying to say.

[AliGW]

Please attach the workbook, then we can advise properly.

[TwistedFaith]

I actually tried but for some reason my Attachment setting isn't working. I'm using Chrome and tried to fix my setting, cookies, cache, ect.. and nothing is allowing me to have the add attachment work.

[AliGW]

Instructions (Please Read Carefully):

Unfortunately the attachment icon doesn't work at the moment (it hasn't worked for years, and despite our repeatedly asking the technical team who own the forum to fix it, they can't be bothered to do so), so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[TwistedFaith]

ok I just edited my previous post and add it.

FYI for that little text book I used a formula for column A:R to input random words based on a select few words. One list for column A and another list for column B:R and because of that it changes every time its refreshed

[AliGW]

Unfortunately you have not mocked up your expected results - please do this MANUALLY and post the workbook again.

[TwistedFaith]

Ok here is the updated copy

[AliGW]

So, just a slight tweak of what I gave you before:

=OR($A2="good",$A2="evil",$A2="bad")

=AND($A2<>"good",$A2<>"evil",$A2<>"bad",$A2<>"")

[TwistedFaith]

Thanks for all the help. That's exactly what I'm looking for.