I would like to use a formula if A1 (e.g.$15) is filled in yellow then A1*2%, if in green then A1*1%.....Is there any way to do that. TIA.
I would like to use a formula if A1 (e.g.$15) is filled in yellow then A1*2%, if in green then A1*1%.....Is there any way to do that. TIA.
Hi,
Check out this site:
OzGrid
Regards,
A
Not without VBA programming code, and even then it wouldn't work well. Don't
use color as information.
HTH. Best wishes Harald
"littleps" <[email protected]> skrev i
melding news:[email protected]...
>
> I would like to use a formula if A1 (e.g.$15) is filled in yellow then
> A1*2%, if in green then A1*1%.....Is there any way to do that. TIA.
>
>
> --
> littleps
> ------------------------------------------------------------------------
> littleps's Profile:
http://www.excelforum.com/member.php...o&userid=25482
> View this thread: http://www.excelforum.com/showthread...hreadid=391785
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks