Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Conditional formatting based on another cell's value
- Thread starter jh3016
- Start date
Highlite row 3...
use conditional formatting...from menu Format>Conditional Formatting...
in condition 1
change the drop down "cell value is" to "formula is"
type
=if(A2>95,true,false)
set the "pattern" to red
-----------
in condition 2
change the drop down "cell value is" to "formula is"
type
=if(A2<95,true,false)
set the "pattern" to green
use conditional formatting...from menu Format>Conditional Formatting...
in condition 1
change the drop down "cell value is" to "formula is"
type
=if(A2>95,true,false)
set the "pattern" to red
-----------
in condition 2
change the drop down "cell value is" to "formula is"
type
=if(A2<95,true,false)
set the "pattern" to green
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question