View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ikaabod[_23_] Ikaabod[_23_] is offline
external usenet poster
 
Posts: 1
Default color changing cells


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