Forum Discussion
Conditional formatting with colours
- Nov 14, 2023
Select A9:F200 or however far down you want.
A9 should be the active cell in the selection.
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=$F9="PT"
Click Format...
Activate the Fill tab.
Specify pink as highlight color (Hex #FF7F92).
Click OK, then click OK again.Repeat these steps but with the formula
=$F9="OM"
and blue (Hex #8EA9DB) as fill color.
Etc. - one rule for each type.
Select A9:F200 or however far down you want.
A9 should be the active cell in the selection.
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
=$F9="PT"
Click Format...
Activate the Fill tab.
Specify pink as highlight color (Hex #FF7F92).
Click OK, then click OK again.
Repeat these steps but with the formula
=$F9="OM"
and blue (Hex #8EA9DB) as fill color.
Etc. - one rule for each type.
- NHodg365Nov 14, 2023Copper ContributorHans you are a genius! This works. I had actually lost hope of managing to do this, but it works! Thank you so much!