Conditional Formatting: If Cell contains Word TRUE or FALSE

[Barlew2]

Hello,

Problem simplified
Cell A1 will contain either the word TRUE or FALSE. I want B1 to change colour when A1 contains either TRUE or FALSE. True Red and False Blue.

Believe me I have tried! It seems any other text is fine, but when setting up Conditional Formatting to look for the text TRUE or FALSE, it seems to be ignoring it??!!

The background to this problem is that I'm exporting the content of a user completed userform into a sheet and if Tick boxes have been checked, the cell will contain TRUE and if not FALSE. Looking to trigger Conditional Formation based on these.

 

[Joe4]

Are these the text values "TRUE" and "FALSE", or the boolean values of TRUE and FALSE?
If text, you need the double-quotes around the words in your Conditional Formatting formula.
If boolean, you need to leave the double-quotes out of your formulas.

 

[Barlew2]

Hi Joe, these are text values...which made me think about formatting the A1 for text....which worked!

Double quotes didn't work, but thanks for the reply

 

[Joe4]

You are welcome.

It is all dependent on how you are entering the data, and how you have written the formulas (since you did not provide that information, we can only guess, but I listed the possible options).