Adaptive Conditional Formatting

cfiramar96

New Member
Joined
Dec 11, 2020
Messages
2
Platform
  1. Windows
Hey there everybody,
I'm working on a sheet that checks if one's answers are correct, based on given answers column.
I want that if a cell value equals to the cell next to it, the cell will turn green (or red if it's not)
I managed to achieve that using conditional formatting,
but the problem is that I need to recreate the same rules over and over again.
That is because if A1=B1 it turns green, but now I need A2 to equal B2, not B1 again - so I can't include A2 on the same rule.
Is there any way of doing so?

Thanks in advance!
(PS English isn't my mother's tongue, so if anything isn't understandable, let me know and I'll explain myself again, thank you)
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,926
Office Version
  1. 365
Platform
  1. Windows
Welcome to the MrExcel board!

The CF should adjust automatically if you don't use $ signs in the formula.
Either ..
  1. Select A1:A?? and apply the CF with formula =A1=B1, or
  2. Select just A1 and apply the formula and then go back in to Cf -> Manage rules and edit the 'Applies to' box

1607734622098.png
 
Solution

cfiramar96

New Member
Joined
Dec 11, 2020
Messages
2
Platform
  1. Windows
Welcome to the MrExcel board!

The CF should adjust automatically if you don't use $ signs in the formula.
Either ..
  1. Select A1:A?? and apply the CF with formula =A1=B1, or
  2. Select just A1 and apply the formula and then go back in to Cf -> Manage rules and edit the 'Applies to' box

View attachment 27808

Not using $ signs did the job, thanks a lot!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,290
Messages
5,595,268
Members
413,982
Latest member
sshvaika

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top