conditional formatting dependent of preceding cell

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?
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2000 - Conditional Formatting 1
Conditional format based on other cells 3
Conditional Formatting dependent on another cell 3
inserting a hyperlink into a conditionally formatted cell, Excel 2 2
Conditional Formatting Help 1
How to move data from rows to columns 6
Macro to paste x number of times 4
Trace Dependent - off worksheet page reference 1

Top