Excel 2000 Validation with colors

  • Thread starter Thread starter MR.WJCA
  • Start date Start date
M

MR.WJCA

Hiya,

A question I'm busy with a form.
In the form, a date list, I want to make notes on different dates for example
F for Full and E for Empty.
Now when I go to a specific date I want to enter a letter
for example F and I want to that the color of the cell then changes
color,from blank to Red (pattern style)
but I want this to happen automaticly (the highlight part)
Now I can activate this with Conditinal Formating (Max 3)
but I was wondering is there an different way which doesn' ask to much
brains :O)

Cheers,

Mr.WJCA
 
You could use an event macro, but conditional formatting hurts the brain a lot
less!

<vbg>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to type each letter of the alphabet automatically in a specific color in Word? 0
How to change color within string? 2
Date with CF 4
Excel Countifs/Sumproduct with mutil Or statement 3
Excel VBA - Problem with Closing Print Preview 0
Create rating with coloring cell 10
Percentage of Cells completed 3
ViewSonic ColorPro VP2776 Pantone Validated Professional Monitor with Color Calibrator Unboxing 3

Back
Top