HI,
i need to be able to change the cell colour to green if the cell is empty
the column is e and the row starts at 6
thanks
steve
HI,
i need to be able to change the cell colour to green if the cell is empty
the column is e and the row starts at 6
thanks
steve
Hi,
Format Conditional Formatting
Format Is =Isblank(A1) adjust to your needs
and pick Format Patterns Green ...
HTH
Carim
hi,
sorry i may have confused you,
but i need the colour to come into effect from e 6 until the last row with data in it
if i have data from e6 to e 20 which is varilbe and 3 of the cell between the rows is blank then turn green
steve
Hi,
Apply formatting as described to cell E6, then with format painter apply it down to cell E22 ...
HTH
Carim
hi,
i am not getting this to work correctly
the last row could vary from e7 to e100 if it does end at e 10 i do not want any cells after that turning green
thanks
steve
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks