Hi,

Is there a way for conditional formatting to detect if a cell has a hyperlink and then to have the conditional formatting change the cell color? meaning, if i have column "E" that has every cell with a unique number and every time I need to create a 'customer order' would use the next available number I have and hyperlink that to his order. However, I want that the cell will change colors as soon as I hyperlink it to customer's order. I really am trying to avoide macros as I don't want this spreadsheet to have any macros.

Please, if anyone can help me out on this issue I will really appreciate it