Previous Topic Next Topic

Help- conditional cell formatting

Solved/Closed
campbellty10 Posts 2 Registration date Monday November 20, 2017 Status Member Last seen November 21, 2017 - Nov 20, 2017 at 12:56 PM
campbellty10 Posts 2 Registration date Monday November 20, 2017 Status Member Last seen November 21, 2017 - Nov 21, 2017 at 09:13 AM
Hello,

I am trying to do some conditional formatting and having a little trouble. Here is what Im looking to get.

I have a column A (estimated price) and Column B (purchased price). I would like to have column B's cell color to change to red if its greater than the value in the adjacent column A cell, and turn to green if that less than.

I can make it work on only one set of cells (lets say B2 compared to A2) but i do not know how to continue this formula for the entire column. I can only do the formating in compare to a single cell (say A2) instead of always reading the corresponding adjacent cell.

Thanks!

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Nov 20, 2017 at 01:27 PM
campbellt10, Good afternoon.

Select your B cell that contains a Conditional Format.

Go to CF Menu
Manager Rules

Change the range at that little blue square at window to your desired range.

Please, tell us if it worked for you.

I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
campbellty10 Posts 2 Registration date Monday November 20, 2017 Status Member Last seen November 21, 2017
Nov 21, 2017 at 09:13 AM
This helped!

I actually had that part in the blue area, I ended up needing to change the formula to match yours.

Looks like I needed to go to new rule and actually write out the formula instead of setting it up through the "greater than" and "less than" buttons under the conditional formatting drop down.

Thanks!

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Excel format
D -
sheryljohnson -

1 response