ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Automatically highlighting cells (https://www.excelbanter.com/excel-discussion-misc-queries/144003-automatically-highlighting-cells.html)

sponger02

Automatically highlighting cells
 
I need to highlight a group of cells when the number in the qty box is
greater than 0. I'm assuming I would need to do this with VB code. Am I
correct, and if so, can someone point me in the right direction?

Thanks for any help in advance.

bj

Automatically highlighting cells
 
check out conditional formatting in Help

"sponger02" wrote:

I need to highlight a group of cells when the number in the qty box is
greater than 0. I'm assuming I would need to do this with VB code. Am I
correct, and if so, can someone point me in the right direction?

Thanks for any help in advance.



All times are GMT +1. The time now is 03:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com