Simple conditional format task not working as expected

[Russk68]

Hi All,

In cell A1 is the word Orange which is a formula resulting from another sheet.
In cell B1 I have a formula =A1 which results: Orange
In cell C1 I have conditional format rule formula: =$B$1="Orange" Format orange fill.
The format rule doesn't work when the formula results in Orange but it does work when I type in Orange in A1 or B1.

The thing here is that the result in A1 comes from different worksheets with other formulas with if statements and such. Does the original source where Orange comes from have anything to do with the final steps here? Is the issue that the final results come from a different sheet? I listed the trail below:

A1 comes from =IFERROR(INDEX('Multi Build'!$G$3:$G$550,MATCH(A5,'Multi Build'!$E$3:E$550,0)),"Color")

The above formula comes from =IF(A3="","",IF(BL$2="By Location",INDEX(Locations!$R$2:$R$75,MATCH('Multi Build'!A3,Locations!$Q$2:$Q$76,0)),IF($BL$2="By Voltage",BH3,"Manual")))

The above comes from a column with Orange in it.

I searched for an answer but I only found issues where a number resulted as text but I don't think it's the case here.

I hope I explained this right!
Thanks all

 

[etaf]

should work

check B by putting

=B1="orange"

whats the formula in B1

check no spaces are occurring

 

[Russk68]

Formula in B1 is =A1
Good point! I've been burned by spaces before.

Thanks!