Conditional Formatting with a Calculated Value

This short video shows how to apply conditional formatting based on a calculated value.

Specifically:
- create the calculated values
- use helper columns as needed
- formula returns a TRUE/FALSE value
- apply conditional formatting
- use a formula to determine which cells to format
- remove helper column
- embed same logic directly into the CF rule

Chapters in this video:
00:00 - Introduction
00:16 - Exercise 1
01:42 - Exercise 2
02:46 - Exercise 3

Also, check out these videos with time saving Excel Hacks:

[rocknrulo]

First time I see your content. Clear, short and usefull, thanks!!
Suscribed since now

[PaulEBrownbill]

Short, sweet, and very useful. Thanks Paul

[RogerStocker]

2:25 deleting the dollar signs for relative cell reference is much easier by pressing [F4] 3x.

[billwenger]

I like the trunc - trick to get the cents separated...

[Mongoose]

Useful tip. It'd be appreciated if you talk a bit slower for us non native speakers.😊