#1
|
|||
|
|||
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!!!! |
#2
|
|||
|
|||
Select D1. Go to Conditional Formatting and choose New Rule and select Use formula.
Insert =A1="??" for the formula. Select red fill. Close. |
#3
|
|||
|
|||
This did it. Thanks so much!!!!
|
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 |
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 |