HELP!!! I've looked for an answer to my problem in the archives, but haven't found anything similar, and hope someone can help.
I have 2 columns of numbers. Here is an example:
Col. A Col. B
98.73 95.40
76.48 74.90
98.22 93.40
71.90 72.50
First requirement is to determine if Col. A number is greater than the adjacent Col B, number. If that condition is true, the Col. A number is changed to Bold type.
Second requirement is to determine if the Col. A number is also higher than 80. If that is true also, then I would like to add light blue background in the cell (along with the number in bold type).
This would result in the first 3 of the numbers in Col. A being boldened, and the Col. A cells containing 98.73 and 98.22 would be filled with a light blue background as well.
Is there an easy way to do this with conditional formatting?
TIA & Merry Christmas
LBTS
I have 2 columns of numbers. Here is an example:
Col. A Col. B
98.73 95.40
76.48 74.90
98.22 93.40
71.90 72.50
First requirement is to determine if Col. A number is greater than the adjacent Col B, number. If that condition is true, the Col. A number is changed to Bold type.
Second requirement is to determine if the Col. A number is also higher than 80. If that is true also, then I would like to add light blue background in the cell (along with the number in bold type).
This would result in the first 3 of the numbers in Col. A being boldened, and the Col. A cells containing 98.73 and 98.22 would be filled with a light blue background as well.
Is there an easy way to do this with conditional formatting?
TIA & Merry Christmas
LBTS