Without a macro you can do the following:
With cell A1 selected, select all cells. Then select Formatting -
Conditional Formatting...
Condition 1:
formula is, =$A1="X"
(change the format to highlight)
Condition 2:
Cell value is, equal to, ="X"
(change the format to highlight)
Where $A1 can be whatever column will contain the X that indicates tha
row is done... so if the "Done X" is in column L instead of A change th
formula to:
=$L1="X"
If by "done X" you mean that all columns in the row are X then you ca
add a column in your spreadsheet that checks this by doing somethin
like this in cell L1 for instance:
=IF(AND(A1="X",B1="X",C1="X",D1="X",E1="X",F1="X", G1="X",H1="X"),"X","No
Done")
This can be done very similarly using a macro. This is just one of
million ways of going about it
--
Ikaabo
-----------------------------------------------------------------------
Ikaabod's Profile:
http://www.excelforum.com/member.php...fo&userid=3337
View this thread:
http://www.excelforum.com/showthread.php?threadid=53659