| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Question
Thanks a ton Ken.
wrote in message ps.com... Select the cell, then click Insert then Name, then define, then type in the name you want. If you name cell A1 of sheet2 "test", then you can type in "test" in a formula, or conditional format condition, or pretty much anywhere you would previously have had sheet2!a1 and it will be pretty much the same. On May 7, 6:11 pm, "Gary" wrote: Ho do I name a cell? wrote in message oups.com... Gary You can't base conditional formatting in one worksheet on a value in another worksheet unless, you are basing it on a named range. If you give cell A1 in Sheet2 a name, say "test", then apply the following two conditionsfto the ormat to cell A1 in Sheet1: =AND(OR($A$1="A",$A$1="B",$A$1="C",$A$1="D"),test= "X") =AND($A$1="E",test="Y") I think you should get what you want. You can probably simpify the one with the OR a little bit. Good luck. Ken Norfolk, Va On May 7, 5:36 pm, "Gary" wrote: Hi All, How do I do the following? If A1 in Sheet1 = A or B or C or D and A1 in Sheet2 = X then A1 in Sheet1 should be red. but if A1 in Sheet1 = E and A1 in Sheet2 = Y then A1 in Sheet1 should be red. Thanks Gary- Hide quoted text - - Show quoted text - |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting question | Excel Worksheet Functions | |||
| Conditional Formatting question | Excel Worksheet Functions | |||
| Conditional formatting question | Excel Discussion (Misc queries) | |||
| Another Conditional Formatting Question | Excel Worksheet Functions | |||
| Conditional formatting question | Excel Worksheet Functions | |||
Threaded Mode
