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 between 310 to 311. if b5 has a value of 6, c6 must be true if it has a value of 311 to 312.
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.
