title: Is it possible to conditionally format the font colour of one column based on the value of another?
body: <p>I have a workbook which identifies valid and invalid names for certain elements within my dataset.</p>
  
  <p>I want to change the colour of the font in each column to the left of wherever the word <code>Invalid</code> appears to red, and to green wherever <code>Valid</code> is shown.</p>
  
  <p>In the example screenshot I provide, I want the value under <code>Identity Data.Name</code> to be listed in red whenever the value of <code>Val Department</code> reads <code>Invalid department</code> and green whenever it reads <code>Valid department</code>.  The same goes for the other columns in the example, too.</p>
  
  <p>(Note that I have narrowed some columns to protect sensitive data, but it doesn't affect the relevance of the image.)</p>
  
  <p><a href="https://i.stack.imgur.com/dopHx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dopHx.png" alt="enter image description here"></a></p>