Hello,
I would like to highlight a row based on a number and letter combination eg 1A, in conditional formating
I know how to do this with text cant seem to figure out with number and text
Many thks
Stu
Hello,
I would like to highlight a row based on a number and letter combination eg 1A, in conditional formating
I know how to do this with text cant seem to figure out with number and text
Many thks
Stu
Try
Formula:Please Login or Register to view this content.
How can you use Conditional Formating.
--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
All the entries in Column B have 2 spaces in front of them. To Conditionally format using the data as it is, select the area that you want formatted and in Conditional Formatting, New Rule, Use Formula, enter this formula
Formula:Please Login or Register to view this content.
If you remove the spaces in column B use this formula instead:
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks