Conditional format

S

samy

Hello,


I have column J & B, when ever i type "Completed" in any cell in column J i
want the cell in B to turn green.
 
C

Chris_Bode via OfficeKB.com

You have to use conditional formatting to apply format conditions to
a range of cells in Excel, any relative addresses will be converted as Excel
adds the format conditions for all the cells.

Follow the following steps
1. Select Column B
2. Click Format>Conditional Formatting…
3. Select Formula Is from drop down list
4. Enter formula as :- =$J1:$J100="Completed"
where range may vary on your need
5. Click Format button, select your color then click OK.
6. Now you can use it as expected…

Have a happy time…..



Chris
 
Top