Conditional Formatting with Cubes

Status
Not open for further replies.

Sphinx404

Board Regular
Joined
May 2, 2015
Messages
186
Office Version
  1. 365
Platform
  1. Windows
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!
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,114,253
Messages
5,546,785
Members
410,757
Latest member
jonni
Top