Hi all, is it possible to change the colour of the font in a row depending on
one of the cell values in that row?
I can obviously use conditional formatting to change the font in the
particular cell that holds the data i will use, but i would like the entire
row to be formatted.

Basically i want the row to change to a light grey font when a particular
cell within that row says complete.

Is this at all possible?

any help appreciated.

Regards

One way:

Assume the target column is B. Select the rows to C, with the active
cell in row 1, then use

CF1: Formula is =$B1 = "Complete"
Format1: <font/<lt grey



In article ,
Maax wrote:

Hi all, is it possible to change the colour of the font in a row depending on
one of the cell values in that row?
I can obviously use conditional formatting to change the font in the
particular cell that holds the data i will use, but i would like the entire
row to be formatted.

Basically i want the row to change to a light grey font when a particular
cell within that row says complete.

Is this at all possible?

any help appreciated.

Regards

Hi JE, sorry i am a little ne to formula's in Excel. Can you please advise
what you mean by CF1:

The column that will have "complete" in it will be M. The first row is 3.

I am unsure what the CF: actually refers too?


Max

"JE McGimpsey" wrote:

One way:

Assume the target column is B. Select the rows to C, with the active
cell in row 1, then use

CF1: Formula is =$B1 = "Complete"
Format1: <font/<lt grey



In article ,
Maax wrote:

Hi all, is it possible to change the colour of the font in a row depending on
one of the cell values in that row?
I can obviously use conditional formatting to change the font in the
particular cell that holds the data i will use, but i would like the entire
row to be formatted.

Basically i want the row to change to a light grey font when a particular
cell within that row says complete.

Is this at all possible?

any help appreciated.

Regards

CF1 == The first (or only) condition in the conditional format


In article ,
Maax wrote:

I am unsure what the CF: actually refers too?

Many Thanks J, as I am a novice i never actually knew there was a drop down
for entering formula in the conditional formatting.

Once i found that it was easy.

Many thanks for your patience.



"JE McGimpsey" wrote:

CF1 == The first (or only) condition in the conditional format


In article ,
Maax wrote:

I am unsure what the CF: actually refers too?

Look at it again and think about it. Could possibly be "conditional
formatting 1"

--
Don Guillett
SalesAid Software

"Maax" wrote in message
...
Hi JE, sorry i am a little ne to formula's in Excel. Can you please advise
what you mean by CF1:

The column that will have "complete" in it will be M. The first row is 3.

I am unsure what the CF: actually refers too?


Max

"JE McGimpsey" wrote:

One way:

Assume the target column is B. Select the rows to C, with the active
cell in row 1, then use

CF1: Formula is =$B1 = "Complete"
Format1: <font/<lt grey



In article ,
Maax wrote:

Hi all, is it possible to change the colour of the font in a row
depending on
one of the cell values in that row?
I can obviously use conditional formatting to change the font in the
particular cell that holds the data i will use, but i would like the
entire
row to be formatted.

Basically i want the row to change to a light grey font when a
particular
cell within that row says complete.

Is this at all possible?

any help appreciated.

Regards

use the format painter

--
Don Guillett
SalesAid Software

"Maax" wrote in message
...
Hi all, is it possible to change the colour of the font in a row depending
on
one of the cell values in that row?
I can obviously use conditional formatting to change the font in the
particular cell that holds the data i will use, but i would like the
entire
row to be formatted.

Basically i want the row to change to a light grey font when a particular
cell within that row says complete.

Is this at all possible?

any help appreciated.

Regards