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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic Cell Background Color

Status
Not open for further replies.
kragster

kragster

Technical User
May 9, 2007
55
DK
Hi. Is there any way to control the background color in a column, so that when the cell is empty the background color is set to red, and yellow if the cell is populated?
 
Sort by date Sort by votes
Have you thought of using Conditional Formatting?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
 
Upvote 0 Downvote




Hi,

No code required.

Check out Format>Conditional Formatting... - its an Excel spreadsheet feature.

Skip,

[glasses] [red][/red]
[tongue]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Getting results from a dynamic dimension array
Replies
2
Views
591
Andrzejek
Andrzejek
remeng
  • Locked
  • Question
Delete dynamic table rows without removing password protection
Replies
7
Views
521
remeng
remeng
dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
689
SkipVought
S
MattGreer
  • Locked
  • Question
Add a formula in a cell that refers to another cell... Not using 'Range' tho 2
Replies
8
Views
301
MattGreer
MattGreer
MattGreer
  • Locked
  • Question
Recalculate Radio-Button-Selected VBA Functions When A Cell Is Updated 2
Replies
18
Views
582
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top