conditional formatting if statement

route217
route217 used Ask the Experts™
on
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.
Comment
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?
route217Junior

Author

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

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.
ChangeColValue.xlsx

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