I have and excel sheet and I have several cells which have conditions set and change color/colour dependant upon the drop down list, but I need a cell to change upon the colour / color of the other cells (Overall) - so if :-
No Red subcategories and no more than one Yellow subcategory...
After 05-JULY-10 a perticular a complet raw should turn into red colour to alert me that its time up to send the invoice. is there any formula available in excel 2007??:confused: If a complete raw is not possible atleast a coloumn can be turn to red colour??
please help me.