I need help, I'm trying to come up of a way that when I type a number on a certain cell, the cells underneath it will be highlighted. For example, I type 5 on cell B2, cells B3 to B7 should turn yellow. Any ideas? or is this even possible?
Click on Format, then Conditional Formatting
Under Condition 1, change Cell Value Is to Formula Is and put in the following formula
Click on Format, then Patterns
Select a color