Share via

Conditional format based on text keeps giving error message

Anonymous
2023-02-04T04:06:11+00:00

I am using Microsoft Office Professional 2019 Excel in Windows 11.

Attempting to create a conditional format, using an absolute text value, i.e.:

=$A$3='Revenue'

I am using an absolute value because I am using only six colors in the spreadsheet, and too much redundancy will make the file too large.

I keep getting an error message and don't know why. I have checked for errant characters, spaces, etc.

I am attaching a screenshot.

Any help trouble shooting would be appreciated.

Thank you.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-02-04T04:57:37+00:00

    Hello, I am Leonielhou, an Independent Advisor and a user like you, I am happy to help clarify any questions you may have.

    How about using this formula?

    =IF($A$3="Revenue", TRUE, FALSE)

    will return a TRUE value if the contents of cell A3 are "Revenue", and a FALSE value otherwise.

    Was this answer helpful?

    0 comments