Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
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?


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
Old 01-01-2019, 01:43 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
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

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

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. is not affiliated with Microsoft