Forum Discussion
Solved
Conditional Formatting Formula Help
Hello! I'm in need of some assistance. I want to have apply a formula that will highlight certain cells if they are greater than 0, but less than the value inputted in another cell. The user ...
Select S14:AG14.
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=AND($AG14>0, $AG14<$AZ$7)
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
Select S14:AG14.
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
=AND($AG14>0, $AG14<$AZ$7)
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
Thank you so much! Worked great!!