Help on Conditional Formatting

[Dougie12.]

HI.

I'm trying to create a conditional format that recognises a specific text (apples) in one column but then highlights the cost in a second column but only when the cost of the apples is over £0.40.

I've attached an example, but not sure how to create the formula.

Can anyone help please?

Thank you

[Pepe Le Mokko]

Select B3:B13 and try

Please Login or Register  to view this content.

as CF. Format as required

[David A Coop]

=AND(A3="Apples",B3>=0.4)

Set your conditional format as above!


When you reply please make it clear WHO you are responding to by mentioning their name.
If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[Fotis1991]

In CF rules

Please Login or Register  to view this content.

[Pete_UK]

Select cells B2 to B13, then click on Conditional Formatting | New Rule | Use a formula. Then enter this formula in the dialogue box:

=AND(A2="Apples",B2>=0.4)

Click the Format button, then click Bold, and in the Color box click on red. Then OK your way out, and Excel will automatically adjust the cell references to suit the highlighted cells.

Hope this helps.

Pete

[Dougie12.]

Thank you Fotis, that's brilliant. Have a good day.

[Dougie12.]

Thanks Pete for your time, everyone has come up with the same formula. Have a good day.

[Dougie12.]

Thank you David. Much appreciated

[Dougie12.]

Thank you Pepe, very kind.

[Fotis1991]

You are welcome-from all of us- and thanks for the feedback.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.