Hello,
I have several rows of numbers, and in each row, I need to check whether numbers after column A are at least 1 less than A, and if they are, I want them to be highlighted. I have attached an example XL2BB with manual highlighting of the relevant cells.
I'm having a hard time with the formula. I wrote this formula, but it highlights entire rows not the particular cells that satisfy the condition:
=($B1:$J1)<=($A1-1)
Also can this be done with just one formula for all the rows? Or each row would need its own formula?
Thanks for any input!
I have several rows of numbers, and in each row, I need to check whether numbers after column A are at least 1 less than A, and if they are, I want them to be highlighted. I have attached an example XL2BB with manual highlighting of the relevant cells.
I'm having a hard time with the formula. I wrote this formula, but it highlights entire rows not the particular cells that satisfy the condition:
=($B1:$J1)<=($A1-1)
Also can this be done with just one formula for all the rows? Or each row would need its own formula?
Thanks for any input!
Book1 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | 3 | 7 | 3 | 6 | 9 | 6 | 8 | 7 | 8 | 7 | |||
2 | 8 | 7 | 3 | 6 | 4 | 4 | 4 | 6 | 3 | 4 | |||
3 | 7 | 7 | 8 | 6 | 4 | 5 | 6 | 6 | 3 | 5 | |||
4 | 9 | 4 | 4 | 4 | 8 | 3 | 5 | 6 | 4 | 3 | |||
5 | 6 | 7 | 3 | 5 | 9 | 8 | 5 | 7 | 8 | 5 | |||
6 | 6 | 3 | 9 | 7 | 6 | 8 | 6 | 4 | 9 | 9 | |||
7 | |||||||||||||
Sheet1 |