I'm attempting to create conditional formatting in which I ask excel to turn any cells in column BU blue if that string value (I usually work in SPSS so I may be mixing terms here) in that column is the same as, and red if it is different from, its corresponding row in BE. I am using the following formulas:
Unfortunately, everywhere I turn on the internet is telling me that these are the formulas I'm supposed to use. Is this outdated information? Excel changes it to ="$BU=$BE" and ="$BU<>$BE" and nothing happens to my $BU:$BU column.