HI ALL,
For now, I'm working with 2 cells. A1, and B1. I want cell B1 to turn blue in color if, A1=(RBS24 - L, or RBS16 - L, or H23 - L).
Help / anyone???
HI ALL,
For now, I'm working with 2 cells. A1, and B1. I want cell B1 to turn blue in color if, A1=(RBS24 - L, or RBS16 - L, or H23 - L).
Help / anyone???
Where RBS24, L and RBS16 are names. H23 is Cell $H$23Please Login or Register to view this content.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
=IF(OR(A1="RBS24-L",A1="RBS16-L",A1="H23-L"),1,0)
Added missing quotations; tested and working.
I assume you want conditional formatting of cell B1? If so, select B1, go to Format > Conditional Formatting, then from the drop-down box, select Formula Is, and type:
=OR(A1="RBS24-L",A1="RBS16-L",A1="H23-L")
Then click the format button and select blue pattern.
HTH
Jason
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks