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.
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.