Forum Discussion
Conditional formatting with colours
Evening all
I have a spreadsheet which I'd like to populate with event details across A-E columns. Column F contains a drop down options. Once an item is selected from the drop down, I'd like that cell and the other cells on that row in columns A-E to change to a designated colour.
I've attached a sample with the key code at the top.
https://www.dropbox.com/scl/fi/3427bxu9zoe5evbnjdzyo/TEST-SPREADSHEET.xlsx?rlkey=kvjt1p8p42xadink7jajs3y0a&dl=0
Can anyone help realise this or am I trying to produce something that's just not possible?
Thanks in advance
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.
2 Replies
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.
- Hans you are a genius! This works. I had actually lost hope of managing to do this, but it works! Thank you so much!
