formula to change colour of text

Here is how you can highlight multiple cells in a row (or the entire row) I did my example below starting in row 2, not 3.

Formula in D2 =IF($A2=TRUE,"~","")

Fill down to complete the column

The ~ character is used in the formula because it is not a typical character found in text. If your text in column A might have a ~ then use a different character in the formula. I often use CHAR(10000) in place of "~".

Creating a highlighting rule for all the cells at one time:

1. Select the cells you want highlighted. In my example I selected B2:C5.
2. Start making a conditional highlighting rule
3. The rule will be "text does not end with"
4. Click on the green oval in the next field (this will make sense when you see it) and click on cell D2.
5. Change it to preserve the column so it will be $D2
6. Click on the green checkmark to accept it. You must use the checkmark.
7. Make it highlight the text in red.

You can add a column

In C2 put this formula that you then drag down

With this formula you tell him to write in C2 the same name as B2 if A2 is true, otherwise it doesn't put anything

=IF(B2;C2;””)

Then choose as conditional highlighting for B2

The text is = cell C2

While for A2 choose conditional highlighting

Cell the value is TRUE

So you select A2 and B2 together and combine rules

The result is what you see in the Screenshots

At the end you can hide column C