If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditonal Format based on multiple criteria
How do you format a cell if the data in the cell contains 1 of several buyers
out of a greater list of buyers. One column in my spreadsheet contains the buyer for that row. I would like to format that cell if certain buyers are entered. eg. Buyer - column heading a b a d c d I would like to format the cell that contain a and d. I tried to use "Or" function. such as OR(C53="a", C53="d") but it did not work. I have excel 2007. Thanks |
#2
|
|||
|
|||
Conditonal Format based on multiple criteria
It should work, if you have done it correct.
Did you remember to put an equal sign before your function ? Suppose you have buyers in C2:C100, select the range and goto conditional formatting, and insert this formula: =OR(C2="a", C2="d") Select the desired format. Hopes this helps. .... Per "Huggy" skrev i meddelelsen ... How do you format a cell if the data in the cell contains 1 of several buyers out of a greater list of buyers. One column in my spreadsheet contains the buyer for that row. I would like to format that cell if certain buyers are entered. eg. Buyer - column heading a b a d c d I would like to format the cell that contain a and d. I tried to use "Or" function. such as OR(C53="a", C53="d") but it did not work. I have excel 2007. Thanks |
#3
|
|||
|
|||
Conditonal Format based on multiple criteria
Thanks, I think it didn't work before because I did not refer to the first
row in the data. It works now. Thanks for the confirmation. "Per Jessen" wrote: It should work, if you have done it correct. Did you remember to put an equal sign before your function ? Suppose you have buyers in C2:C100, select the range and goto conditional formatting, and insert this formula: =OR(C2="a", C2="d") Select the desired format. Hopes this helps. .... Per "Huggy" skrev i meddelelsen ... How do you format a cell if the data in the cell contains 1 of several buyers out of a greater list of buyers. One column in my spreadsheet contains the buyer for that row. I would like to format that cell if certain buyers are entered. eg. Buyer - column heading a b a d c d I would like to format the cell that contain a and d. I tried to use "Or" function. such as OR(C53="a", C53="d") but it did not work. I have excel 2007. Thanks . |
Thread Tools | |
Display Modes | |
|
|