Conditional Formatting exception formula

ichow88 

To achieve conditional formatting that highlights cells with the value "N" but excludes "N/A" and other variations like "N - xxxx," you can use a custom formula.

Here is a formula you can use:

=AND(ISTEXT(A1), A1<>"N/A", LEFT(A1,1)="N")

This formula uses the AND function to combine multiple conditions:

• ISTEXT(A1) checks if the cell contains text.
• A1<>"N/A" ensures that the cell value is not exactly "N/A."
• LEFT(A1,1)="N" checks if the first character of the cell value is "N."

Here are the steps to apply this formula for conditional formatting:

1. Select the range of cells where you want to apply conditional formatting.
2. Go to the "Home" tab on the ribbon.
3. Click on "Conditional Formatting" in the toolbar.
4. Choose "New Rule."
5. Select "Use a formula to determine which cells to format."
6. Enter the formula: =AND(ISTEXT(A1), A1<>"N/A", LEFT(A1,1)="N")
7. Set the formatting options you desire.
8. Click "OK" to apply the rule.

This formula should highlight cells that start with "N" but exclude "N/A" and other variations. Adjust the cell reference (A1 in this example) based on your actual range.

Note: If your data is in a different column or range, you need to adjust the formula accordingly. The text and steps were edited with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.