Copying Conditional formatting with relative cell referencces in the formula desn't work

Morisn 

Hi, Bonjour!

Dear Oscar,

Hope your are doing well,  as I opened my outlook today, read your e-mail concern and quickly started to trial the formula that you have put forward.  As I had similar concern last year and got some help here and some formula just worked, just by changing values here and there.

So here is your formula that you need to modify a little bit to get what you need to do in M.S Excel.

Formula: =NOT(ISBLANK($A2)) Format: Amber Applies to: =$B$2:$F$2,$B$2:$F$300

The difference here is that we are applying formula to cell reference only and format to whole table array.

This formula does the intended work as a result.

Just apply conditional formatting to one of the cell and copy that cell up to ranges you're applying to.

Here is the formula snapshot.

https://paste.pics/IU8M3

Hope this works for you and get the most out of M.S Excel.

Thanks & Regards

Hamad B

Hello there,

Since I don't know if this thread is still alive, I'll be very brief. I am having a similar problem with formatting but what I want to achieve is the following:

Simply, every time that I enter 'Y' on Column A, I want the entire row to change colour. As simple as that.

Actually, I don't even care if it's Y or Nay, as long as that row changes colour when it's not blank. Since I am not allowed to add images in this thread, I am sending the Gyazo link where I captured the examples I want to show.

But first, the formula.

I created a rule first, for row no. 2 as follows:

Formula: =NOT(ISBLANK($A$2)) Format: Amber Applies to: =$B$2:$E$2

When trying to figure out how to replicate, the only way I was able to do it the way I wanted was to duplicate the formula and change its values manually. 

I did that 6 times before I got tired.

The rows I added and modified can be seen here:

https://gyazo.com/2fbd83b871a38ddccba5f01f044362e9

And a sample of the results:

First date row (2) with a 'Y' changes row no. 2 colour to amber:

https://gyazo.com/1c8fce73dee70e8397c6ec161406d6ca

And another one:

https://gyazo.com/23e82b0e0bdd83e82dbde7dceee2edcf

Now, for a few rows, it's doable; however, this is completely impractical and backwards for software such as Excel to be doing this for any number of rows. So there should be a better way to do this.

I have about 300 records to apply this to and may be more.

Hopefully, someone could give me an idea of how to go about this.
Thank you and regards,
Oscar

StevanMuller12 

Rule formula could be like =$B2<>$C2 applied to entire range as B2:C999.

With sample file which shows the same data as on screenshot it'll be easier to demonstrate.

Good Day,

We are trying to show the difference in price change of 2 lists of sku and prices.
And original conditional formatting does not have a rule for this help will be much appreciated.