conditional formatting dependent of preceding cell

  • Thread starter Thread starter Beth W
  • Start date Start date
B

Beth W

Can you set a conditional format dependent of the cell in the previous
column. Example cell B2 dependent on A2, B3 dependent on A3, etc?
 
1. Select the cOLUMN b
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=A1<5
4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK

If this post helps click Yes
 
Back
Top