View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Redsphynx Redsphynx is offline
external usenet poster
 
Posts: 22
Default counting coloured fields

No, the column doesn't go green until I tell it. It is for a register, and
once I have verified that the number (column) is associated with a person,
then I select entire column, and change it green. That tells me at a glance
what numbers I have verified, and what ones I haven't.

"T. Valko" wrote:

Can you create a formula based on the logic of *why* the "fields" are green?

For example, they're green because they're less than 100 or they're green
because they're Monday dates.

--
Biff
Microsoft Excel MVP


"Redsphynx" wrote in message
...
Hi,

I need to keep a tally on how many fields are green in a given row. Is
this
possbile? If so how?