Think you will have to use the calculate event. I tried a UDF in conditional
formatting, and it caused excel to crash. Even if used through a defined
name.

Maybe someone else knows a better trick.


--
Regards,
Tom Ogilvy


"TheRook" wrote:

Yes, I think so. The cell will be filled in by someone so the same logic can
not be adapted.

I am not experienced in VBA but have previously posted regarding counting
coloured cell and thought there maybe a simular way to do this.

Cheers

"Tom Ogilvy" wrote:

If B1 is filled with bright green by conditional formatting, then you would
use similar logic for the other cell. Instead of Cell Value is, you might
need to change the dropdown to formula is in the Conditional formatting menu.


If the cell is colored by the user, then there would be no easy way to
detect that since coloring a cell does not trigger an event or a recalculate
and there are no built in functions that will detect the coloring of a cell.
You could write a user defined function in VBA possibly, is that what you
want?

--
Regards,
Tom Ogilvy


"TheRook" wrote:

I am wanting to conditionally format a cell so that it fills the cell in
bright green if a specific cell is formatted bright green. Example

If A1 is filled bright green, B1 would automatically fill in bright green.

Is this possible