Coloured Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know of any function that returns a value based on the colour of
a given cell.
 
"Function for colour of cell" <Function for colour of
(e-mail address removed)> wrote in message
Does anyone know of any function that returns a value based on the colour of
a given cell.
Click to expand...

The FontColor and BackColor properties of a textbox (or a spreadsheet cell,
in Excel) can be read or set at runtime. Those properties in Access can only
be saved in Design View.

In a continuous form, the font color and back color can be set for a field
using Conditional Formatting. Access datasheet colors apply to the entire
datasheet.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Arvin,

How are you holding up after this last one?
Ready to move to Oregon yet?
 
Depending which way the wind's blowing, he may be there yet!

Arvin posted to our private group that he survived with little damage this
time, but I suspect it may be a while before he's back posting here.
 
Hi Doug,

Yeah, you could be right on the wind!

Good to hear he's OK.
Thanks for the update.
 
Douglas J. Steele said:
Depending which way the wind's blowing, he may be there yet!

Arvin posted to our private group that he survived with little damage this
time, but I suspect it may be a while before he's back posting here.
Click to expand...

It would take more than a stinking hurricane to keep me away. For a while
there I was using a generator to juice up my computer.

Nah! Y'all are stuck with me. :-)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Hi Arvin!
It would take more than a stinking hurricane to keep me away. For a while
there I was using a generator to juice up my computer.
Click to expand...

Now there is a true Access Junkie!
Nah! Y'all are stuck with me. :-)
Click to expand...

We wouldn't want it any other way Arvin!
Good to hear you are OK!
 
You must log in or register to reply here.

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

Excel Remove Excel Background Colours 1
Bar charts colour 3
Adding a colour permanently to the MS Office colour palette 6
Excel Conditioning Formatting 3
Excel How to change lines in graph to individual colours 0
Word Conditional Formatting in Word 0
Excel Formatting with dates 3
Excel Conditional Formatting Removal 7

Back
Top