Dynamic Conditional Formatting

[Quesexcel]

I am trying to figure out the best way to color cells in a specific column that correspond to and adjacent cell in another specific column. The columns come in in different order so the location is not always in the same place. I would like to have conditional formatting color in the values in the column "Des" red for each occurrence of the letter X in column Bes, and color the value green for each occurrence of y.

 

[rahulshewale1]

Hii @Quesexcel ,

Try below formula

=IF(B2="X",TRUE(),FALSE())
=IF(B2="Y",TRUE(),FALSE())

Select D column range >
Go to contional formating > new rule > formula > paste formula > select formating >
> Ok



Regard
Rahul shewale

 

[pecoflyer]

The IF function is implicit in CF as is the array formula), no need to use it
=$B2="X"
=$B2="Y"
for each format will suffice