Conditional formatting rule how to set with two or two more conditions

Thanks, already done

Hello & Welcome to the Forum,

Adjust ranges to suit...

Conditional Formatting

• Highlight applicable range >> A2:B100
• Home Tab >> Styles >> Conditional Formatting >> New Rule
• Select a Rule Type: Use a formula to determine which cells to format
• Edit the Rule Description: Format values where this formula is true: =AND(OR($A2="John",$A2="Yuki"),$B2<10)
• Format… [Number, Font, Border, Fill]
• OK >> OK

Change...

A2:C100

=AND(OR($A2="John",$A2="Yuki"),$C2<10)

Not sure the underline should cause a problem, but how about attaching a sample file so we can get you the best outcome.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.