Color cell question

[zibblate]

How do I make this happen?

If the number in E2< the number in 'Time for Upgrade'!D2... Then turn E2 pink.

Thanks in advance
Zibb

 

[VoG]

This should help http://www.contextures.com/xlCondFormat02.html

 

[Smitty]

You can use Conditional Formatting.

Select E2 and goto Home-->Conditional Formatting-->Use a formula to determine which cells to format-->=E2<'Time For Upgrade'!D2-->Format as desired.

HTH,