CODEWITHSUNDEEP
excelcopycellpaste
user3654187
user3654187

Reputation: 1

Excel 2011 copy formula/rule headache

I'm trying to set up a formula or rule (don't know which is the best to do this) on excel 2011. So for cell A1, I want to type in a value. I want cell B1 to show it in green if the value is more than A1 or red if it's less. 1) I also want to copy this formula or rule down column B so that it will change according to the value in column A (A1:B1, A2:B2, A3:B3, etc). If possible, I also want to copy this formula or rule to columns C, D & E so that if the value in cell C1 is greater than the value in B1, it will turn green and red if it's less, etc. Thank you in advance.

Upvotes: 0

Views: 274

Answers (1)

David
David

Reputation: 1

What you need is Conditional formatting. Steps to perform:

  1. Click a cell
  2. Go to menu: Format -> Conditional Formatting,
  3. Choose formula based formatting.
  4. Edit based on your formula

You can use the copy formatting icon to copy this conditional formatting to the whole column

Upvotes: 0

Related Questions