I am trying to use conditional formatting so that if cell b2 is greater than
a2 the number will be coloured red. I then want to apply this to a range so
that the references will change automatically. What is the best way to do
the formula?
I am trying to use conditional formatting so that if cell b2 is greater than
a2 the number will be coloured red. I then want to apply this to a range so
that the references will change automatically. What is the best way to do
the formula?
If you want to apply to B2:B10 so that all cells are coloured red if greater than column A in same row
select B2:B10
Format > Conditional Formatting > Formula is
=B2>A2
select red formatting
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks