Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-16-2022, 12:00 PM
Bigsur2 Bigsur2 is offline Need formula to format one cell if another cell includes specific text Windows 10 Need formula to format one cell if another cell includes specific text Office 2021
Novice
Need formula to format one cell if another cell includes specific text
 
Join Date: Jun 2022
Posts: 20
Bigsur2 is on a distinguished road
Default Need formula to format one cell if another cell includes specific text

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



Any help is appreciated!!!!
Reply With Quote
  #2  
Old 11-16-2022, 01:09 PM
mrgramm mrgramm is offline Need formula to format one cell if another cell includes specific text Windows 10 Need formula to format one cell if another cell includes specific text Office 2021
Novice
 
Join Date: Jan 2020
Posts: 7
mrgramm is on a distinguished road
Default

Select D1. Go to Conditional Formatting and choose New Rule and select Use formula.
Insert =A1="??" for the formula. Select red fill. Close.
Reply With Quote
  #3  
Old 11-17-2022, 11:53 AM
Bigsur2 Bigsur2 is offline Need formula to format one cell if another cell includes specific text Windows 10 Need formula to format one cell if another cell includes specific text Office 2021
Novice
Need formula to format one cell if another cell includes specific text
 
Join Date: Jun 2022
Posts: 20
Bigsur2 is on a distinguished road
Default

Quote:
Originally Posted by mrgramm View Post
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!!!!
Reply With Quote
Reply

Thread Tools
Display Modes


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
Need formula to format one cell if another cell includes specific text 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
Need formula to format one cell if another cell includes specific text Delete cell content that has a specific format Daniel Arbeit Excel Programming 1 06-20-2016 03:02 PM
Need formula to format one cell if another cell includes specific text 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 11:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft