Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003
I want to have a field autofill with color if the letters MR or SR are
somewhere in the cell. I can not figure it out. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003
Look up Conditional Formatting in Help. HTH Otto
"Stepha" wrote in message ... I want to have a field autofill with color if the letters MR or SR are somewhere in the cell. I can not figure it out. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003
HI Stepha
Select the range you would like to format then go to FormatConditional Formatting change " Cell Value is " to " Formula is " next box copy this formula =OR(--(A2="mr"),OR(--(A2="sr"))). This formula assume that the first cell in your range is A2 change it to your needs then press Format and Pattern and choose your colour. HTH John "Stepha" wrote in message ... I want to have a field autofill with color if the letters MR or SR are somewhere in the cell. I can not figure it out. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003
I'm note quite sure what you are trying to do with your two OR functions and
the two double unary minuses, John, but why =OR(--(A2="mr"),OR(--(A2="sr"))) and not just =OR(A2="mr",A2="sr") ? -- David Biddulph John wrote: HI Stepha Select the range you would like to format then go to FormatConditional Formatting change " Cell Value is " to " Formula is " next box copy this formula =OR(--(A2="mr"),OR(--(A2="sr"))). This formula assume that the first cell in your range is A2 change it to your needs then press Format and Pattern and choose your colour. HTH John "Stepha" wrote in message ... I want to have a field autofill with color if the letters MR or SR are somewhere in the cell. I can not figure it out. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003
HI David
Just not taking the time to think maybe going to fast. Thanks "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... I'm note quite sure what you are trying to do with your two OR functions and the two double unary minuses, John, but why =OR(--(A2="mr"),OR(--(A2="sr"))) and not just =OR(A2="mr",A2="sr") ? -- David Biddulph John wrote: HI Stepha Select the range you would like to format then go to FormatConditional Formatting change " Cell Value is " to " Formula is " next box copy this formula =OR(--(A2="mr"),OR(--(A2="sr"))). This formula assume that the first cell in your range is A2 change it to your needs then press Format and Pattern and choose your colour. HTH John "Stepha" wrote in message ... I want to have a field autofill with color if the letters MR or SR are somewhere in the cell. I can not figure it out. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 attachments open and show only empty cells when openedvia Outlook 2003? | Excel Discussion (Misc queries) | |||
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |