Need a CF formula.

[serge]

Hi, I'm looking for a CF formula that will highlight in red any set combination that will go over the number in cell AB1 which here is 70.

Thank you.

 

[Joe4]

Follow these steps:

1. Select the range W5:AA8
2. Go to Conditional Formatting
3. Select "New Rule: and then choose the "Use a formula to determine which cells to format" option
4. Enter in the following formula:

=$AA5>$AB$1

6. Click the "Format" button
7. Go to the "Fill" tab and select the red color
8. Click OK twice

This should do what you want, as shown below:

 

[serge]

Thank you Joe4 that's exactly what I needed, really appreciate the help.

 

[Joe4]

You are welcome.
Glad I was able to help!