Condtional Format

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

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"
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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?
 
Back
Top