Highlight Cell

Phill9080

New Member
Joined
Mar 17, 2015
Messages
34
could any please advise how I can highlight a cell red if the below appear in the cell when typed

CAR201 CAR202 CAR203 CAR204 CAR205

would be much appreciated
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
Are you saying that you want the cell to turn red if ANY of those 5 values appear the cell?
Will the cell equal EXACTLY one of those values, or will the value be just part of the text? i.e.
Bill is driving CAR201
 
Upvote 0
I think the most straightforward way would be to use conditional formatting... e.g. highlight cell rules, highlight cells that contain text CAR201, then another rule for CAR202 etc...
 
Upvote 0
Then use Conditional Formatting.
Highlight the entire range you want to apply this to.
Then go to Conditional Formatting, select the Formula option, and enter this formula:
Code:
=OR(J1="CAR201",J1="CAR202",J1="CAR203",J1="CAR204",J1="CAR205")
where J1 is the address of the first cell in your range
and choose your red formatting option.
 
Upvote 0
And is that the cell you have referenced in the CF formula? There is nothing at all in the CF formula given that would cause a blank cell to be formatted.
 
Upvote 0
With the CF formula applied to the range $J$1:$J$8:

Excel 2016 (Windows) 32 bit
J
1
2
3
CAR203
4CAR208
5
6
7
8

<colgroup><col style="width: 25pxpx"><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,253
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top