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.

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.

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.