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

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

Win 7 Ultimate (64-bit), Win 8.1.1 (64-bit)
 
 

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

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

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

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

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 for2: excel 2010 conditional formating
Thread Forum
Excel 2010 Microsoft Office
[Office 2010]Unable to Fill Conditional format down the entire Column Microsoft Office
Solved Excel 2010 help Microsoft Office
excel 2010 Microsoft Office
Formatting Excel 2010, Excel 2003 Microsoft Office
Solved Excel 2010 Microsoft Office
Excel 2010 and Web Queries 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:58 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33