Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-03-2011, 08:49 AM
Lucky Lucky is offline Conditional formatting with AND, OR Windows XP Conditional formatting with AND, OR Office 2007
Novice
Conditional formatting with AND, OR
 
Join Date: Oct 2011
Posts: 2
Lucky is on a distinguished road
Question Conditional formatting with AND, OR

Hi All,
I need to add conditional formatting on a cell.
A requirement is: if the cell should be highlighted yellow if value contains letters A, F, or T.

I’m trying to use “Format only cells that contain” -> Cell value -> Equal to -> AND (“A”, “F”, “T”), but looks the excel takes it literally ="AND(""A"", ""B"", ""C"")"



What would you recommend?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting namedujour Excel 3 08-25-2011 01:46 PM
Conditional formatting with AND, OR help with conditional formatting Snvlsfoal Excel 3 07-03-2011 11:55 PM
Conditional formatting with AND, OR * Conditional Formatting MS 2010 djreyrey Excel 3 06-03-2011 01:54 AM
Conditional formatting of Today +21 days? SHERMAN Excel 3 12-20-2010 08:08 AM
Challenge!! Need help though. (Conditional formatting) knuckles70 Excel 2 02-05-2010 12:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:16 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft