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...
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
=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
- Thank you so much!! That worked perfectly!!!
