Color formatting using VBA

May be

Please Login or Register  to view this content.

AB33,

I clarified my question above. Your code runs an infinite loop.

For Each cel In Range("B4:L484")
is finite loop.
You must be referring to your own code

I ran your code. It pops up the MsgBox "I'm busy" as an infinite loop. Did you read the code I posted in Post #1?

I do not know what do you mean by infinite loop?

Range("B4:L484"). There is lower(B4) and upper boundary(L484).
Or do you want to exit the loops soon as you get the message?

The MsgBox "I'm busy" will not go away, this is what I mean by infinite loop. I want to exit the loop as soon as I get the message, yes!!

I am not sure which one is yes, but you can move out Exit For below MsgBox ("I'm busy")

Please Login or Register  to view this content.

Ok that works better, but what I'm trying to do is put the message in cell. For example, the cell N4 at the end of the row, it needs to say either "I'm free" or "I'm busy." In this case, the cell N4 would say I'm busy.

My range is from B4 to L484. For example for the first row, B4 to L4, there is a red slot, so in N4 it needs to say "I'm busy" in the cell.

IdealTasks.xlsm

Ideally this is how it should look for all the rows (see attached). I want to automate this process by looking at the colors in each row.

Please Login or Register  to view this content.

It gives me the error "Object or variable not set"??

Please Login or Register  to view this content.

RGB(255, 255, 255) is the color for white

Please Login or Register  to view this content.

Object required error??

If I declare the variable, do I declare it as a Range?

Please Login or Register  to view this content.

I'm using concatenation because I need all the cells from B to L to be white cells, in order for the N cell to say "I'm free".

Please Login or Register  to view this content.

Could you provide an example of what that loop structure would look like?

Please Login or Register  to view this content.

The error is telling me there is no Else statement for my If statement. Is the code out of order??

That works perfectly!!!!! Thanks This has been solved!