Beginner Conditional Formatting Question

[PleaseHelpMeLearn]

HI Forum,

I am able to use conditional formatting to fill a cell with a certain color (green) if its value is greater than another cell, and fill it red if its value is less than that cell. But I am having a hard time copying these rules to other relative cells. For example if B1 is greater than A1, it fills green. If B1 is less than A1, it fills red.

What do I do so these same rules apply to B2/A2, B3/A3, etc?

Thanks in advance!

[TMS]

If there are dollar signs ( $ ) in front of the 1s, remove them.

[PleaseHelpMeLearn]

Thank you, I will try that now.

[PleaseHelpMeLearn]

Hi, it didn't seem to work. I'm not sure what I am doing wrong? I have attached a screenshot of the conditional rules, perhaps if you or anyone who sees this has a moment you can tell me what I'm doing wrong? Thank you!

[davsth]

follow the instructions in the yellow banner to attach a file. the above attachment doesn't open for me

[PleaseHelpMeLearn]

Attachment 686782

Trying again to attach file. Sorry. I am terrible with computers but trying to learn.

I am trying to get the values in column N to either turn red or green depending on if the value is lower or higher than the value in the adjacent cell. The values in N will be updating regularly so I'd like the color to change accordingly. Thank you!

[TMS]

Select cells N3 to N6 and use the CF Formula:

Please Login or Register  to view this content.

[PleaseHelpMeLearn]

thank you!!!

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.