Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Condtional Format Question | Excel Worksheet Functions | |||
condtional formatting not working | Excel Worksheet Functions | |||
condtional format to | Excel Worksheet Functions | |||
Condtional format of row depending on string value of $A2 + | Excel Discussion (Misc queries) | |||
Condtional formatting | Excel Worksheet Functions |