conditional formatting based on text color

[MuffinTops]

Hi, complete excel newbie here

I'm trying to work out a way for certain confirmed vs unconfirmed dates in a large spreadsheet to standout.

If the text in a cell eg F1 is red then I need the text in G1, H1, I1 and J1 to also be in red.
If the text in cell F1 is black then I need the text in n G1, H1, I1 and J1 to also be in black

is that possible?

thanks in advance. i've been googling and watching videos on youtube for hours unsuccessfully .

[bebo021999]

Is colour of F1 manual painting?
If it is, try with VBA. Formula can not read format.

[MuffinTops]

it is manual (for now. i might change it)
thank you

now to work out what a VBA is

[davesexcel]

Hello,
What determines the text color?

[Croweater]

There is no trigger event on a format change, however this code might help you achieve what you want.

It will sort out your font colours as per the request if you click in column F, after you've changed your font colour.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim ocell As Range

    If Not Intersect(Target, Range("F:F")) Is Nothing Then
        For Each ocell In Range("F:F")
        If ocell.Font.ColorIndex = 3 Or ocell.Font.ColorIndex = 1 Then
            Range("G" & ocell.Row & ":J" & ocell.Row).Font.ColorIndex = ocell.Font.ColorIndex
        End If
        Next ocell
    End If
End Sub