Jan 12 2023 12:39 PM - edited Jan 12 2023 12:40 PM
Jan 12 2023 01:00 PM
Let's say the data are in B2:B50, D2:D50 and F2:F50.
Hold down Ctrl and select D2:D50.
Still holding down Ctrl, select B2:B50.
You should now have selected all three ranges, with B2 as active cell.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.
Jan 12 2023 11:27 PM
Jan 12 2023 11:38 PM