Conditional Formatting with Cubes

[Sphinx404]

Not sure if it's my syntax or order of operations but I cannot get my conditional formats to work....

Choosing: Format only cells that contain...

Cell Value>greater than>

my formula: =$Y$43-$X$41/2+$X$43

I suck at conditional formatting... always have problems... (probably because I don't do it enough).

Could one of you please take a look and let me know where I've gone wrong with the formula? Placing it in parenthesis doesn't seem to help.... =($Y$43-$X$41)/2+($X$43)???

Thanks!

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...nal-formatting-formula-error.html#post5064182

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).