Formulas for conditional formatting

[DarkoDeign2]

Hi,

I have a file with dates and follow up status.
I would like help with the conditional formatting for the dates in column v, x, z to change based on the values W, Y and AA.

The default format of the date in column V is that the font is Bold and in red.
Below are possible combinations and the wished outcome of this.

Example 1
IF W2="NO" and AA2="ONGOING", don't change the formatting in cell V2. Cell X2 and Z2 should remain empty.

Example 2
IF W3="YES" and AA3="ONGOING", Change the format in cell V3 (regular font and in black font color).
Cell X3= bold font and font color red

Example 3
IF W4="YES", Y4="YES" and AA4="ONGOING", Change the format in cell V4 and X4 (regular font and in black font color).
Cell Z4= bold font and font color red

Example 4
IF W5="YES", Y5="YES" and AA5="Closed", Change the format in cell V5, X5 and Z5 (regular font and in black font color).

I hope you can help me with this.

 

[Joe4]

Since example 1 does not involve any Conditional Formatting, you should only need formulas for examples 2, 3, 4.

Example 2
IF W3="YES" and AA3="ONGOING"

Formula to use:

=AND($W3="YES",$AA3="ONGOING")

Example 3
IF W4="YES", Y4="YES" and AA4="ONGOING"

Formula to use:

=AND($W4="YES",$Y4="YES",$AA4="ONGOING")

Example 4
IF W5="YES", Y5="YES" and AA5="Closed"

Formula to use:

=AND($W5="YES",$Y5="YES",$AA5="Closed")