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]

Presumably you're color coding the cells in Column A based on some value. Why not just setup a conditional formatting rule in Column D to format as some color based on the same values?

Form example, let's say in A1:A3 I am formatting values in green if they're <0. I'd create a conditional format rule for D1:D3 that formats them as red if A1:A3 > 0. Here's an example of what I mean:

	A	B	C	D	E
1	-3			1
2	8			2
3	-1			3

<tbody>
</tbody>

I setup a conditional format rule where if the values in A1:A3 < 0, format the text as green. I then created another conditional format rule for D1:D3 where I format based on the formula =A1<0 and format the font as red.

 

[Fluff]

Formulae cannot detect the colour of a cell.
How is text colour of A3 being set?

 

[Bravo33]

The data in Column A is text. The colour of the text will be manually changed or ideally based on a selection from a drop down.
There will be 4 colour options for the required text conditions.
The text conditions will be (Current; Superseeded;Omitted;Duplicated; Not applicable)
Where all columns that intersect row the condition set in say A4 will be duplicated in cells B4:Z4 and so on.

Thanks,

 

[Fluff]

In that case select the range you want the CF to work on (Say A2:Z20)
Then in CF > New rule > Use a formula > =$A2="Current" Then select the format you want

 

[Bravo33]

Sorry, Should have elaborated.
Column A contains a list of documents. There could be up to 1000 documents.
These documents are either, Current; Superseeded;Omitted;Duplicated or Not applicable.
The document name will have different colour text according to its state.
So any document that is "Current" the text will be black
Superseeded the text colour will be Grey and so on.

Thanks,

 

[Fluff]

Is there a column that shows the status of a document?

 

[Bravo33]

Is there a column that shows the status of a document?

No, just a change in text colour in column A
I would rather not have a seperate column defining the status as this could be inadvertently changed. Where as is the text colour in a Column A cell has be be manually changed this focusses on the action required with less opportunity for error.

 

[Indystick]

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

 

[Fluff]

As I said in post#3

Formulae cannot detect the colour of a cell.

So to use conditional formatting, there has to be a logical rule.