Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-01-2019, 01:01 AM
LearnerExcel LearnerExcel is offline Windows 7 32bit Office 2013
Advanced Beginner
 
Join Date: Nov 2016
Posts: 68
LearnerExcel will become famous soon enoughLearnerExcel will become famous soon enough
Default How to highlight the cells using conditional formatting?

Hi,



I have numbers in column "C" which either starts with first 2 letters as "35" or "45". I would like to highlight the numbers which starts with "45" as first two characters using conditional formatting. How can I do that? Please support.
Reply With Quote
  #2  
Old 01-01-2019, 01:43 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,335
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Select col C
use =LEFT($C1,2)="45" as CF and format as required



Happy New Year
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to highlight cells using Vlookup / conditional formatting mikehk Excel 2 09-18-2017 07:30 PM
Conditional formatting to color cells based on number kallard Excel 4 12-26-2016 11:10 AM
Conditional Formatting for Cells Containing Formula Gillian623 Excel 1 12-09-2016 11:03 PM
Disappearing Cells Issue (Possibly Related to Conditional Formatting) sk8blitz23 Excel 6 03-02-2016 03:06 PM
Conditional Formatting- Only format cells once data is entered chart3 Excel Programming 1 12-15-2015 11:26 AM


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft