Yea you can do it,

if you comfortable wiht coding tey using for each loop with each row, or you
can loop through cells like you doing and select the entire row and then
change the color of the row.

I guess it might work
Anand.V.V.N


--
"Who will guard the guards?"


"akemeny" wrote:

I need to set a Macro (possibly in VBA) that will change the color of a
selected number of cells based on the text in another cell.

For example:

When A1 states - FI the row turns orange
When A1 states - ALJ the row turns green
etc.

Since I need to do this to many rows is there also a way to set this by
column rather than cell text?