Forum Discussion
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 would input a value in cell AZ7.
When the user types in a value in cell AG14 that is greater than 0 or less than the value in AZ7, then the row of cells (S14:AG14) would be highlighted.
I've figured out with conditional formatting how to highlight AG14, but not the rest of the cells in that row. Any help would be greatly appreciated!
Thank you!
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.
2 Replies
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!!
