Conditional Formatting based on Text Color

**JBailey-LMC** · 04-25-2013, 03:06 PM

Column A - Entered Text
Column B - Entered Date
Column C - Formula (Column B + 180 days)
Cell A1 =TODAY()

Column C has conditional formatting to turn text RED if C<$A$1

I would like to have columns A and B also turn RED if C is RED.

Any suggestions?

**Lemice** · 04-25-2013, 03:14 PM

Hello,

You can also do that by pasting a formula into your conditional format, like =C<$A$1 (On cell A2 for example, enter =$C2<$A$1)

**JBailey-LMC** · 04-25-2013, 03:21 PM

Thanks Lem...Just saying it out loud got me on the right track.

**Tony Valko** · 04-25-2013, 03:22 PM

Let's assume your data is in the range A5:B10

Select the range A5:B10

Conditional Formatting

Use a formula to determine which cells to format

Use this formula: =$C5<$A$1

Set the desired styles

OK out