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

Bigsur2 · #1 11-16-2022, 12:00 PM

For example, if A1 has "??" as a text entry, I'd like D1 to format with red fill.

Any help is appreciated!!!!

mrgramm · #2 11-16-2022, 01:09 PM

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

Bigsur2 · #3 11-17-2022, 11:53 AM

Quote:

Originally Posted by mrgramm

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

This did it. Thanks so much!!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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