Microsoft Office Forums - View Single Post - [Solved] If color is red then active

Thread: [Solved] If color is red then active

View Single Post

Old

01-08-2012, 11:33 PM

ruby_2014

ruby_2014 is offline

ruby_2014 uses Windows 7 32bit

Windows 7 32bit ruby_2014 uses Office 2010 32bit

ruby_2014 uses Office 2010 32bit

Office 2010 32bit

Novice

The original poster

Join Date: Jan 2012

Posts: 1

ruby_2014 is on a distinguished road

Default

If color is red then active

Hi,

could anyone help me with the formula, i have cells with red,green and yellow colors..

if the celll is red the display expired and yellow display about to expire and green to active.

any help is appreciated.

thanks

Reply With Quote