If cell A1 is larger than B1 color fill A1 red. I have Excel 97 and don't know visual basic.
B Beergut Oct 7, 2004 #1 If cell A1 is larger than B1 color fill A1 red. I have Excel 97 and don't know visual basic.
N Norman Jones Oct 7, 2004 #2 Hi Beergut, You do not need to use VBA. Look at Conditional Formatting. If you are not familiar with Conditional Formatting see Debra Dalgleish's excellent tutorial and examples at: http://www.contextures.com/xlCondFormat01.html
Hi Beergut, You do not need to use VBA. Look at Conditional Formatting. If you are not familiar with Conditional Formatting see Debra Dalgleish's excellent tutorial and examples at: http://www.contextures.com/xlCondFormat01.html
B Beergut Oct 7, 2004 #3 Thanks Norman. That works. BG Hi Beergut, You do not need to use VBA. Look at Conditional Formatting. If you are not familiar with Conditional Formatting see Debra Dalgleish's excellent tutorial and examples at: http://www.contextures.com/xlCondFormat01.html Click to expand...
Thanks Norman. That works. BG Hi Beergut, You do not need to use VBA. Look at Conditional Formatting. If you are not familiar with Conditional Formatting see Debra Dalgleish's excellent tutorial and examples at: http://www.contextures.com/xlCondFormat01.html Click to expand...
