Forum Discussion
excel
I would like to know how to format paa true or false, a cell that depends on the value of another will have a certain range. For example, c6 will be true if b5 has a value of 5, c6 must be betwee...
Do you want to format (color) C6 conditionally, or do you want to restrict the values you can enter depending on the value of B5?
WISH TO FORMAT.Select C6.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=OR(AND(B5=5,C6>=310,C6<311),AND(B5=6,C6>=311,C6<312))
Click Format...
Activate the Fill tab.
Select a color.
Click OK, then click OK again.
