Forum Discussion
Conditional formatting to change the colour of entire row
Hi!
I have a column(C2) which specifies if I have purchased or sold the particular a share. Is it possible for me to add conditional formatting in the spreadsheet such that if the cell has value "buy" it will colour code the entire row GREEN and if the cell has value "sell" it will colour code the entire row RED?
1 Reply
Let's say you want to apply this to rows 2 to 100.
Select these rows in their entirety. The active cell in the selection should be in row 2.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula=$C2="buy"
Click Format...
Activate the Fill tab.
Select green as fill color.
Click OK, then click OK again.Repeat these steps, but with the formula
=$C2="sell"
and red as fill color.
