Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

conditional format or a formula

0

Hi i need to find a way to automatically change the font and background cell when data is entered into a different cell as seen in the sample column h  has  a format rule where any text containing TP the font and background change colour but i also need the data in column j on the same row of each entry to change colour as well 

Answer
Discuss

Answers

0
Selected Answer

Graham

Your existing Conditional Formatting rule (for column H) reads:

  • Format only cells that contain
  • Specific Text containing
  • TP

This actually equates to a formula (for H1) of:

=NOT(ISERROR(SEARCH("TP",H1)))

In the attached file, I've changed the Rule Type to Change to Use a formula... and made the formula read:

=NOT(ISERROR(SEARCH("TP",$H1)))

where the $ fixes the column.

After clicking OK, I then (carefully) changed "Applies to" from =$H:$H to

=$H:$H, $J:$J 

then pressed OK.

Now existing cells in J have the same green formatting as TP entries in H and if you make a cell in H contain the text TP, the cell in J of that row also gets the same formatting.

Hope this helps.

Discuss

Discussion

THANKYOU FOR YOUR HELP
grahamscown (rep: 8) Jan 7, '23 at 7:54 pm
Glad that worked for you. Thanks for selecting my Answer, Graham. I just corrected some typos in my Answer. 
John_Ru (rep: 6092) Jan 8, '23 at 8:22 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login