Hello,

It's possible by formula to know the color of cell ?

I tried with the formula CELL ("color",cell_reference) but this one just
tell me if the the cell has been formatted with color for negative numbers.

I want to know if the cell has been filled with a specific color and in that
case assign a value to another cell, something like:

if cellXY_color = "yellow" then
cellZV = "OK"

Thanks

A couple of quick questions...

1. How did the cell get to be yellow in the first place? Conditional Format
or Manually selected. If contional format then we can use the logic that
turned it yellow to make the coresponding cell value "Ok"

2. If the colour was selected manually then we need to write code taht
recognizes the colour of cells which is relatively easy code. Did you wnat
the prograam to:
A. at the push of a button run through a spreadsheet that has already been
coloured.
B. define the corresponding cell at the time when a cell is coloured.

3. Define Yellow. There are lots of shades of yellow...

"Ayda" wrote:

Hello,

It's possible by formula to know the color of cell ?

I tried with the formula CELL ("color",cell_reference) but this one just
tell me if the the cell has been formatted with color for negative numbers.

I want to know if the cell has been filled with a specific color and in that
case assign a value to another cell, something like:

if cellXY_color = "yellow" then
cellZV = "OK"

Thanks