IF formula and conditional formating

Hi,

I have this formula in an excel, in other columns to bring a higher value: =IF(E2>A2, "Yes", "")
How can I use in a conditional formatting?
I want to highlight a value in columns where one value is higher than other, like:

A B C D E
30 15 2 5 35
15 10 11 5 5
2 4 52 2 4


So, I need the formula to look at column A, and check B, C, D and E and highlight any value in those column where B,C,D or E is higher than A across the excel.
Is it possible with conditional formatting ?


Thanks a lot

or this one: =$A2<A2

Thanks, but I can't make it work.
I need something to check column B,C,D,E,F,G that will tell me if is higher than column A.
It highlighted other cells maybe because I put incorrect formula?


Sample.PNG

Thanks again!

Both of the formulas provided will work. You just have to apply them correctly.

To apply the Conditional Formatting formula from post #2, try this:
Highlight B2:G100 (or however far down your data goes) > Conditional Formatting > New Rule > Use a formula

=B2>$A2

Format: Fill Yellow > OK > OK

If you selected the cells starting with B1, the formula that you would have to use would be this:

=B1>$A1

or simply select range A:G suitably and use it from post #3

the best way is attach example excel file

Originally Posted by sandy666

or simply select range A:G suitably and use it from post #3

Sandy, if the user selects A:G, wouldn't the formula have to be =$A1<A1 ?

in A1 are headers
I said suitably so OP should know where are OP's numbers

Right, but with Conditional Formatting, the formula has to start with the top left of the selected range.

The top-left of A:G is A1.

If you select A:G and then use =$A2<A2, wouldn't the CF be off by one row as seen in the screenshot in post #4?

Gosh!, suitably means eg. A2:G20 or any other range

Understood. Didn't mean to derail this thread.

Thanks a lot.
It worked.... as you guys said.... all you need is knowing where to put the formula and select it correctly.

Much appreciated.

no problem


If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it - ignore it.
Thank you.