Forum Discussion
Conditional formatting range of cells based upon specific value of cell for that column
Hi I want to create a tracker template with conditional formatting for a range of sales growth red if value is less than a specific cell value and green if value is greater than the value of a cell i...
Let's say you want to apply this to O5:S100.
Select this range. O5 should be the active cell in the selection.
Set the fill color to red. This will be the default.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Format only cells that contain'.
Leave the first drop down set to 'Cell Value'.
Select 'greater than' from the second drop down.
In the box next to it, enter the formula
=O$4
Click Format...
Activate the Fill tab.
Select green as fill color.
Click OK, then click OK again.
- Thank you. I also tried this option, and it worked as well!
