Forum Discussion
Jessica_Leandro
May 13, 2022Copper Contributor
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...
HansVogelaar
May 13, 2022MVP
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?
- Jessica_LeandroMay 13, 2022Copper Contributor
WISH TO FORMAT.- HansVogelaarMay 13, 2022MVP
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.