I have two columns in Excel as shown on the picture below.
I need to apply conditional formatting in this way:
if row in B column contain "1", the cell A on the same row should change its color. This needs to be applied only for the cell in A column, not whole row. Is there any option how to do this?
Highlight Cells Based on Another Cell To highlight cells based on another cell's value, you can create a custom formula within a conditional formatting rule. Select the range you want to apply formatting to. In the Ribbon, select Home > Conditional Formatting > New Rule.
Click in the column, then choose Editor > Conditional Formatting > Highlight Cell > Greater Than. Click in the column, right-click, then choose Conditional Formatting > Highlight Cell > Greater Than.
Follow these steps and your problem will be solved ;)
=$B2=1
Yellow
=$A$2:$A$7
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With