Condtional Format
 

I admit i'm not good at formulas at all, I have tried on this simple thing
without success.

When a specific name is entered say Peter, John or David I want the cell to
go bold and turn red.

I have tried this where you put the formula bit in: ="Peter" OR "John" OR
"David"

Condtional Format
 

In the Conditional Formatting dialog box enter the formula:

=OR(D2="Peter",D2="John",D2="David")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Dave" wrote in message
...
I admit i'm not good at formulas at all, I have tried on this simple thing
without success.

When a specific name is entered say Peter, John or David I want the cell
to go bold and turn red.

I have tried this where you put the formula bit in: ="Peter" OR "John" OR
"David"

Condtional Format
 

In regards to the same question as Dave.

Example:
The cell (call it cell A2 for this example) now says 'Peter' and it has
turned red/bold. How would you make cell A1 turn red/bold whenever A2 turns
red/bold?

"Sandy Mann" wrote:

In the Conditional Formatting dialog box enter the formula:

=OR(D2="Peter",D2="John",D2="David")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Dave" wrote in message
...
I admit i'm not good at formulas at all, I have tried on this simple thing
without success.

When a specific name is entered say Peter, John or David I want the cell
to go bold and turn red.

I have tried this where you put the formula bit in: ="Peter" OR "John" OR
"David"

Condtional Format
 

Give A1 the same CF rule as A2


Gord Dibben MS Excel MVP


On Tue, 17 Jul 2007 17:32:01 -0700, bennos
wrote:

In regards to the same question as Dave.

Example:
The cell (call it cell A2 for this example) now says 'Peter' and it has
turned red/bold. How would you make cell A1 turn red/bold whenever A2 turns
red/bold?

"Sandy Mann" wrote:

In the Conditional Formatting dialog box enter the formula:

=OR(D2="Peter",D2="John",D2="David")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Dave" wrote in message
...
I admit i'm not good at formulas at all, I have tried on this simple thing
without success.

When a specific name is entered say Peter, John or David I want the cell
to go bold and turn red.

I have tried this where you put the formula bit in: ="Peter" OR "John" OR
"David"