| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format a range dependant on another cell
can i format a range of cells dependant on another cell's input? for example,
i want N34 through N44 to change yellow if cell M32 has text in it. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
format a range dependant on another cell
1. Select the cell/Range (say N34:N44).
2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =ISTEXT($M$32) 4. Click Format ButtonPattern and select your color (say Yellow) 5. Hit OK PS: If you are using XL2007 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format. Enter the formula in the box below. -- Jacob "JeremyC." wrote: can i format a range of cells dependant on another cell's input? for example, i want N34 through N44 to change yellow if cell M32 has text in it. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
format a range dependant on another cell
Select N34:N44
Format Conditional Formatting Formula Is =$M$32<"" Click Format and choose youre the properties of your format and hit OK -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Jacob Skaria" wrote: 1. Select the cell/Range (say N34:N44). 2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =ISTEXT($M$32) 4. Click Format ButtonPattern and select your color (say Yellow) 5. Hit OK PS: If you are using XL2007 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format. Enter the formula in the box below. -- Jacob "JeremyC." wrote: can i format a range of cells dependant on another cell's input? for example, i want N34 through N44 to change yellow if cell M32 has text in it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change text format dependant on formula result | Excel Worksheet Functions | |||
| Find Last cell in Range when range is date format | Excel Discussion (Misc queries) | |||
| Populating a Range Dependant on a List | Excel Worksheet Functions | |||
| Select a range of data dependant on the users input ie dates | Excel Discussion (Misc queries) | |||
| How to assign a score, dependant on a sum falling within a range? | Excel Discussion (Misc queries) | |||
Linear Mode
