Conditional Formatting with 5 conditions! Can it be done?!

[lesley9]

I think I'm going to need a combination of If, AND & TRUE but just not sure!

Here's the problem...

I want to show in G2 if cells B2:F2 meet the targets dependant on if there is text in cell B2. No text then cells C:F must be >= than 'Target 1' (I3:K3). Text then cells C:F must be >= than 'Target 2' (I7:L7)
Problem.jpg



Help!

[6StringJazzer]

I don't understand how this question relates to conditional formatting. It sounds like you want a Yes or No in column G to show if the target is met. I think that would be

Please Login or Register  to view this content.

But I cannot test that formula on an image. Just attach the Excel file. It's easier than taking a screenshot first and then attaching that.

It will be much easier to understand your problem if you provide your file. This allows us to see and experiment with your data, layout, formulas, code, and possibly attach a file with a completed solution. If you are looking for formulas to produce a desired result, it helps if you create a mock-up of what you want the result to look like. Otherwise we would have to build something from scratch, trying to guess what you want it to look like.

Under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

[lesley9]

Thank you. That formula works great to display Yes or No.

Sorry, I was thinking I would need conditional formatting in column G. I'll add the spread sheet next time. Sorry again and thanks very much for your help.

[6StringJazzer]

Does that mean your problem is solved? Or do you still need conditional formatting for something?