Conditional Formatting - Formulas with IconSets
 

Hi!

Could somebody please tell me how to setup a formula(s) with 3 traffic
lights in that a particular column will display a red circle if a particular
col in the same row has a blank. Then I need to do this for each cell of the
corresponding column.

(Blank), red x
Non-Blank, green check

Conditional Formatting - Formulas with IconSets
 

So, something such as:

http://6aqawg.bay.livefilestore.com/...matIconSet.bmp

http://6aqawg.bay.livefilestore.com/...tDataTable.bmp





"genxgeek" wrote:

Hi!

Could somebody please tell me how to setup a formula(s) with 3 traffic
lights in that a particular column will display a red circle if a particular
col in the same row has a blank. Then I need to do this for each cell of the
corresponding column.

(Blank), red x
Non-Blank, green check