I'm trying to set up Conditional formatting so that if B6 = F then all cells selected where the formula entered into Conditional Formatting applies would be filled with a specific color. I highlight all the desired cells, go to conditional formatting, select :Use a formula to determine which cells to format and have tried a few formulas such as
=IF(B6,"F")
But that's not working. Any ideas?
Thanks in advance
=IF(B6,"F")
But that's not working. Any ideas?
Thanks in advance