can you give a more detailed example of what you need
for example
if you want A2 to change colour - but based on a value in say C2
then select A2
then use a formula
=$C2 = " value you want to change cell A2 colour "
Book2 |
---|
|
---|
| A | B | C | D |
---|
1 | | | | |
---|
2 | | | | |
---|
3 | | | fred | |
---|
4 | | | | |
---|
5 | | | | |
---|
6 | | | fred | |
---|
7 | | | | |
---|
8 | | | | |
---|
9 | | | | |
---|
|
---|
for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting
Highlight applicable range >>
A2:A100 - Change, reduce or extend the rows to meet your data range of rows
Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=C2 = "Fred" )
Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK