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!
Bookmarks