conditional formatting if statement

route217 used Ask the Experts™
Hi Experts using excel 2010

I want to add to cell d6 if this cell is blank then tbc using conditional formatting...if user added text then leave text.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
What value do you want to populate in D6 by Conditional Formatting?


If d6 is blank or left empty then add tbc..
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Make a new rule for conditional formatting using the below formula as set the format as per your choice.

Open in new window

You cannot Set a Cell Value using Conditional formatting.

You can do this by adding a simple VBA code. Attached an excel which explains it.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial