Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: excel 2010 conditional formating

20 Aug 2013   #1
paascal

win 7 u x64
 
 
excel 2010 conditional formating

hello im trying to have a filter for specific text. i would like the cell to be green if : yes or ok are in the cell how can i do this ?

i assume there must be various symbols for x AND y, x OR y


My System SpecsSystem Spec
.
20 Aug 2013   #2
strollin

W7 Ult desktop, W10 laptop, W10 laptop, W8.1 tablet
 
 

This should give you the basics: MS Excel: Change the font color based on the value in the cell in Excel 2010

You want to set a rule based on the rule type "Format only cells that contain" then set it up to look for specific text.



Set up 2 rules, one for Ok and the other for Yes. Doesn't matter about the case, it will work regardless.
My System SpecsSystem Spec
20 Aug 2013   #3
paascal

win 7 u x64
 
 

yes i knew how to use this... i would like the text to change color if : ok OR good or nice or great is in the cell... obviously with only one conditional formating rule
My System SpecsSystem Spec
.

21 Aug 2013   #4
TanyaC

Linux Mint 17 Cinnamon | Win 7 Ult x64
 
 

Yes, you would use something like this in the formula for your conditional formatting

=OR(A1="Nice",A1="Great",A1="Yes",A1="ok")
Format... Color

And make sure you set it to apply to all the cells you want to format

Tanya
My System SpecsSystem Spec
21 Aug 2013   #5
paascal

win 7 u x64
 
 

last question: how can i write the formula so that it applies on column A, not only cell A1 :S
My System SpecsSystem Spec
21 Aug 2013   #6
TanyaC

Linux Mint 17 Cinnamon | Win 7 Ult x64
 
 

The formula allows you to set the range that the formatting applies to... See the attached image...


Attached Images
 
My System SpecsSystem Spec
Reply

 excel 2010 conditional formating




Thread Tools




Similar help and support threads
Thread Forum
Bug in Excel 2010?
For my workbook, I have defined the default font to be 11 pt Calibri. However, when I select a row (or column) and select Clear Formats, the cells are reformatted to 10 pt Arial. To me, this seems like a bug. Am I missing something?
Microsoft Office
How to go back from Excel 2010 64 bit to Excel 2010 32 bit
I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In...
Microsoft Office
Excel advanced conditional editing help needed
Hi I have two excel files. One is inventory and other is ip plan. The inventory document has a alot of data. Of them One column is of computer name and second is ip. The ip plan has one column consisting of ip and next to it the user name and some other information. Now I want the ip...
Microsoft Office
Excel 2010
Hello, I'm having this weird problem with MS Office 2010. When I'm working on excel files tend to crash for no reason and too frequently when I try to open them. I have gotten these two messages: 1) Excel cannot complete this task with available resources. Choose less data or close other...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Excel 2010
Hi all I'm trying to add a little Calculator function to a Spreadsheet I use for trading shares. I pull basic data from YAHOO finance and would like to have at the bottom of a spreadsheet a calculator which would allow me to enter Nr of shares bought, Price Paid and return things like Profit /...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 09:11.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App