Need formula to format one cell if another cell includes specific text

		Microsoft Office Forums > Microsoft Excel > Excel
Need formula to format one cell if another cell includes specific text

11-16-2022, 01:09 PM

mrgramm

Windows 10 Need formula to format one cell if another cell includes specific text

Office 2021

Novice

Join Date: Jan 2020

Posts: 7

Select D1. Go to Conditional Formatting and choose New Rule and select Use formula.
Insert =A1="??" for the formula. Select red fill. Close.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA Word : identify empty cell and aply specific format	Denalei	Word VBA	2	01-05-2022 12:41 AM
How to copy data to a specific cell by clicking on source cell?	LearnerExcel	Excel	3	08-25-2021 04:46 AM
How do I test a cell for a specific word if the cell has a drop down list.	RoehamptonTech	Excel	1	08-23-2017 05:05 AM
Delete cell content that has a specific format	Daniel Arbeit	Excel Programming	1	06-20-2016 03:02 PM
Need a formula to copy cell data with its format	wfhin2016	Excel	12	04-23-2016 08:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:00 AM.