Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

EXCEL POPULATING CELLS

Status
Not open for further replies.
gc1234

gc1234

Programmer
Mar 4, 2004
94
0
0
GB
Hi all,

Just wondered if its possible to put text in a cell when a row is changed to a certain colour>?

gc
 
Sort by date Sort by votes
Hi,

No, but you can change the Interior COLOR of a cell when a VALUE changes to a certain text.

However, it can be done with VBAm if you want to pursue that. And THAT depends on what makes the Interior Color or the row change.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

N1GHTEYES
  • Question
Count range overlap cells
Replies
3
Views
132
N1GHTEYES
N1GHTEYES
Bijugate
  • Question
Excel update question
Replies
0
Views
100
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
128
combo
combo
ladyck3
  • Locked
  • Question
Excel 365 - Auto-Populating a cell from date in the next cell. 2
Replies
9
Views
111
ladyck3
ladyck3
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
150
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top