Simple Spreadsheet programming help

**theebookzoo** · 08-25-2008, 12:05 PM

Hello,
I have a spreadsheet that I need a m acro for, that will look at cell U3, if it is a 0 (zero) then hightlight cell C3 yellow. And so on, if U4 is zero, highlight U4..
Also look at the cells below,
cell U4, if it is a 0 (zero) then hightlight cell D4 yellow. And so on...
Can anyone help me with this?

The macro will be behind a button on the spreadsheet. I dont know if that makes a difference or not.
Thanks!!!

**MartinShort** · 08-25-2008, 02:35 PM

You don't need to use a macro, use conditional formatting instead.

1) Select Cell C3, and choose conditional formatting from the Format menu.

2) Change Condition 1 to "Formula is".

3) In the Formula box type

"=U3=0"

4) Change the required format to Yellow Cell Shading.

5) Copy this formatting down the entire range you want to select.

If you need to exclude null cells, use

"=AND(ISNUMBER(U3),U3=0)"

as the suggested formula in point 2) interprets Nulls as Zeros.

**arthurbr** · 08-25-2008, 03:27 PM

Hi, as you haven't answered my last message about what the thread title should be, I am closing this thread.
Please feel free to open an new one with a relevant title
Cheers