Conditional Formatting

[RodneyC]

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

 

[Fluff]

How about

=B6="F"

 

[RodneyC]

How about

=B6="F"

 

[RodneyC]

How about

=B6="F"

Nope, that's not working

 

[Fluff]

In that case can you post some sample data, showing expected results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[Sufiyan97]

Try

=$B$6="F"

 

[RodneyC]

In that case can you post some sample data, showing expected results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

It's a company computer and I'm not permitted to download items like this. It's a global rule for the company.

 

[Sufiyan97]

It's a company computer and I'm not permitted to download items like this. It's a global rule for the company.

Have you tried suggestion in post #6?

 

[RodneyC]

It's a company computer and I'm not permitted to download items like this. It's a global rule for the company.

I highlight cells A2 - I2 and go to Conditional Formatting and set it up like this, using the various options I've seen posted.

 

[Sufiyan97]

Isn't it be B2 in formula?