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 "bu...
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.