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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,109,503
Messages
5,529,248
Members
409,857
Latest member
KailuaTown
Top