Changing cell colors in a row IF...
Dan
You can probably use conditional formatting, with the condition
something like:
=AND($A2<"",$B2<"",$C2<"",$D2<"",$E2<"",$F2< "",$G2<"",$H2<"",$I2<"",$J2<"",$K2<"")
Copy this to all the rows you want to change color when you have
non-blank entries in columns A through K.
Good luck
Ken
Norfolk, Va
PS I just noticed that your data goes through AK, not just K. I will
send an alternate solution later, assuming you don't wnat to extend the
AND() by another 26 checks. I was pretty bored after just 11.
Mr. Dan wrote:
I have 300+ rows of data. I'd like to change the cell color of a row (or,
more specifically, columns A through AK) when a complete date is entered into
a cell in that row.
Thanks in advance!!!
|