Conditional Formatting based on value in another column

Hi,

I have a value in column H7 as 2000
I have columns M to X labeled Jan to Dec. I want to highlight in yellow values in the row M7 to X7 if they are greater than 2000!

Then, I need to copy this conditional formatting down the columns under M to X, but under column H the values will be different, but I still want the same results, values greater than the value under column H then highlight in yellow
I thought I had the answer but when I tried to copy down, it was making cells yellow that were clearly less than the column H value.

Any help will be appreciated!

Hi Bigroo1958,

can you post the file or an example of the data?

Thanks

1. highlight the range you want to apply the conditional formatting to (M7:X100...or whatever your range is)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =M7>$B7 format fill yellow

Thanks FDibbins,

I tried "use formula option" but I only entered in =$H7 and I was only highlighting on row, row M!
Thanks works nicely indeed.

Also, thanks Noboffinme, I was about to attach an example when I seen the latest post and reply, I appreciate the offer of help!

Thanks

FDibbins,

I have attached my demo sheet with dummy data.
Why is the cell in row 10 still looking at H7 when you review the CF formula?

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)