Conditional Formatting based on another cells text colour

[Bravo33]

I've done an search on this an cannot find a solution.

I wish to apply a conditional format to a row of cells text colour Cells D3:Z3

Based upon the cell text colour at A3

A3's cell

Any help appreciated.

 

[Indystick]

Not necessarily. What I meant was you just have some criteria you use to determine which cells get which color. E.g., Entry X superceeds Entry Y because Z.

Whatever that rule is can likely be turned into a conditional formatting rule.

 

[Bravo33]

Presumably there is some logic by which you go through and change the colors in each row of Col A. What is it?

This is for Contruction Tender document managment by project.
So, I receive a tender pack from the Client which can contain up to 1000 documents of various types. pdf; Word; Dwf; Dwg and so on.

During the Tender process documents are amended / updated and sent out. Documents become obsolete and some documents are highlighted in a specific colour according to their file extension(ie Dwg;Dxf etc)

The concept is a complete history of the Tender document process and whilst documents can be added to the list no documents can be deleted.
The colour coding is to see is where documents have changed their status.
ALL current documents remain black text.

Many thanks,

 

[Fluff]

If there is nothing in the sheet that signifies what colour certain rows should be (other than manually applied text colour), then you cannot use conditional formatting.

 

[Fluff]

As you are changing the text colour manually, why not just apply it to the entire row, rather than col A?