I would like to fill different color based on the value of letter and number
in a cell. For example if I type in letter S and any number after letter S I
want to have different color. If I type in letters OP and any number after OP
I want to see different color. I have more than three conditions to place. I
am using Excel 2003.

This cannot be done with CF.

You would need VBA.


Gord Dibben MS Excel MVP

On Fri, 26 Feb 2010 14:54:01 -0800, Kimti
wrote:

I would like to fill different color based on the value of letter and number
in a cell. For example if I type in letter S and any number after letter S I
want to have different color. If I type in letters OP and any number after OP
I want to see different color. I have more than three conditions to place. I
am using Excel 2003.

Thanks for the response, what would I need to do in VBA?

"Gord Dibben" wrote:

This cannot be done with CF.

You would need VBA.


Gord Dibben MS Excel MVP

On Fri, 26 Feb 2010 14:54:01 -0800, Kimti
wrote:

I would like to fill different color based on the value of letter and number
in a cell. For example if I type in letter S and any number after letter S I
want to have different color. If I type in letters OP and any number after OP
I want to see different color. I have more than three conditions to place. I
am using Excel 2003.

.

First I need to know if I have interpreted correctly.

You type an S and any number after that.

You want just the number font to be colored?

Or entire cell to be fill-colored?


Gord

On Mon, 1 Mar 2010 15:56:01 -0800, Kimti
wrote:

Thanks for the response, what would I need to do in VBA?

"Gord Dibben" wrote:

This cannot be done with CF.

You would need VBA.


Gord Dibben MS Excel MVP

On Fri, 26 Feb 2010 14:54:01 -0800, Kimti
wrote:

I would like to fill different color based on the value of letter and number
in a cell. For example if I type in letter S and any number after letter S I
want to have different color. If I type in letters OP and any number after OP
I want to see different color. I have more than three conditions to place. I
am using Excel 2003.

.

Hi Gord,

I want to fill entire cell with different color. I can make the groups and
go with three conditions. I would prefer if I can use CF.

Thanks for your help.

Kimti

"Gord Dibben" wrote:

First I need to know if I have interpreted correctly.

You type an S and any number after that.

You want just the number font to be colored?

Or entire cell to be fill-colored?


Gord

On Mon, 1 Mar 2010 15:56:01 -0800, Kimti
wrote:

Thanks for the response, what would I need to do in VBA?

"Gord Dibben" wrote:

This cannot be done with CF.

You would need VBA.


Gord Dibben MS Excel MVP

On Fri, 26 Feb 2010 14:54:01 -0800, Kimti
wrote:

I would like to fill different color based on the value of letter and number
in a cell. For example if I type in letter S and any number after letter S I
want to have different color. If I type in letters OP and any number after OP
I want to see different color. I have more than three conditions to place. I
am using Excel 2003.

.


.