Conditional formatting range of cells based upon specific value of cell for that column

[AnnaC1325]

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 in that particular column.  For example: 

HIghlight the cells in column O based upon if their value is greater (GREEN) or (RED) less than Value in O4 and so on.    Please

Help

[#2]

Highlight the range to highlight (let's say it is O5:S14) then select conditional formatting and select Use custom formula and use this formula:
=O5>=O$4
and then select format and choose green background
The KEYs here are
a) that O5 in this example is the upper left corner of the range selected (the Applied To range)
b) the $ in O$4 will "lock" the comparison to always use row 4 so as excel bounces cell to cell it will always use the cell in row 4 but the column will shift as it looks at other columns so when it looks at P5 it will compare to P4
repeat for < and color red
OR highlight the whole range red/green and only use 1 conditional formatting rule

[#3]

@AnnaC1325 

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.

[#4]

Thank you so much!! That worked perfectly!!!

[#5]

Thank you. I also tried this option, and it worked as well!